Testing variants of CTAS
Category: 19c
CTAS Performance
Tune CTAS statements on Oracle Database
Manage Sessions in Oracle Database
Review of methods to manage Oracle Database sessions
Overview: SELECT SAMPLE
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 19.0.0.0.0 - Production Version 19.3.0.0.0 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…
Read More Estimate Defragmentaton Benefits for a Bigfile Tablespace