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. We use a table with 9 000 000 rows and seelct from it with a […]Read more "Overview: SELECT SAMPLE"
Database: Oracle Database 19c Enterprise Edition Release 220.127.116.11.0 – Production Version 18.104.22.168.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: […]Read more "Estimate Defragmentaton Benefits for a Bigfile Tablespace"