Comparing Oracle Databases: Initialization Parameters

A method for comparing the Oracle init parameters of several PDB’s

CTAS Performance II: TESTING

Testing variants of CTAS

CTAS Performance

Tune CTAS statements on Oracle Database

Manage Sessions in Oracle Database

Review of methods to manage Oracle Database sessions


One feature that many developers and data analysts are not aware of is the SAMPLE function in Oracle. It is quite an old feature (not sure exactly when it was added). Below is a simple example of how it works.…

Estimate Defragmentaton Benefits for a Bigfile Tablespace

Database: Oracle Database 19c Enterprise Edition Release - Production Version I write this post in order to follow step by step how a bigfile tablespace is created and managed in 19c. The main purpose is to find a…

%d bloggers like this: