Category: 19c

Comparing Oracle Databases: Initialization Parameters

Posted by on in 19c, db, Oracle, SQL Developer, techLeave a comment

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

CTAS Performance II: TESTING

Posted by on in 19c, db, Oracle, techLeave a comment

Testing variants of CTAS

CTAS Performance

Posted by on in 19c, db, Oracle1 Comment

Tune CTAS statements on Oracle Database

Manage Sessions in Oracle Database

Posted by on in 19c, db, Oracle, Scripts, techLeave a comment

Review of methods to manage Oracle Database sessions

Overview: SELECT SAMPLE

Posted by on in 19c, db, Oracle, tech, Unjustly IgnoredLeave a comment

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.…

Read More Overview: SELECT SAMPLE

Estimate Defragmentaton Benefits for a Bigfile Tablespace

Posted by on in 19c, db, Oracle, techLeave a comment

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

%d bloggers like this: