Radu Pârvu

Notes on tech, tools, and thinking

    Welcome to Radu Parvu’s site on tech and news of the world!

    Overview: SELECT SAMPLE

    19c

    • Overview: SELECT SAMPLE

      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

      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 way to estimate the space benefits of defragmenting the tablespace. I will use two methods.

    • Oracle Live SQL Tool

      Oracle Live SQL Tool

      https://livesql.oracle.com/apex/f?p=590:1000:100225800561367