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.
Continue reading “Overview: SELECT SAMPLE”
Database: Oracle Database 19c Enterprise Edition Release 126.96.36.199.0 – Production Version 188.8.131.52.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 way to estimate the space benefits of defragmenting the tablespace. I will use two methods.
Continue reading “Estimate Defragmentaton Benefits for a Bigfile Tablespace”