(Richard Foote) In Part I, I introduced the new Index Advanced Compression default value of “HIGH”, which has the potential to significantly compress indexes much more than previously possible. This is due to new index compression algorithms that do more than simply de-duplicate indexed values withi
Tag: Oracle
Queue-based Concurrent Stats Prototype Implementation
(Randolf Geist) This is just a prototype of a queue-based concurrent statistics implementation – using the same basic implementation I’ve used a a couple of years ago to create indexes concurrently.
Early ADF Model Update with Process Updates Method
(Andrejus Baranovskis) This use case specifically useful for ADF UI value change listener. If there is business logic to be invoked when field value is changed, we can can call ADF BC custom method from assigned value change listener.
Rename Pluggable Database
(mgogala) I stumbled upon a convenient way to rename a pluggable database:
Oracle TAN Function with Examples
(Ben) In this article, I’ll explain the Oracle TAN function, what it is, and show you some examples.
Oracle 12.2 New Feature: SQL*Plus History
(Gokhan Atil) While playing with Oracle 12.2 Database on the Oracle Cloud, I noticed that SQL*Plus has a new feature which would be very useful for all DBAs. Now SQL*Plus can keep history of the commands executed, and let you see and run these commands from the history.
Evaluating Cluster Dispersion in Oracle Data Mining
(Brendan Tierney) When working with the Clustering algorithms, and particularly k-Means, in the Oracle Data Miner tool there is no way of seeing how compact or dispersed the data is within a cluster.
Viewing Automatic SQL Tuning Advisor Tasks in Oracle SQL Developer
(Jeff Smith) I got a question from our internal mailing list…
Oracle Developer Cloud Service and ADF Build/Deployment Automation Summary
(Andrejus Baranovskis) We are moving our internal development to Oracle Cloud production instance. This weekend I was going through build automation and deployment process with Oracle Developer Cloud Service.
Oracle SIN Function with Examples
(Ben) In this article, I’ll explain what the Oracle SIN function is and show you some examples.
