How to identify table fragmentation and remove it ? Posted on December 18, 2018 , Modified on October 13, 2026 , by Yannick JaquierTable of contents Preamble Legacy situation Newest methods to estimate tables size Table fragmentation identification Move, shrink or export/import ? References Read more Oracle SQL, Tuning 11 comments
How to non intrusively find index rebuild or shrink candidates ? Posted on November 23, 2018 , Modified on October 12, 2026 , by Yannick JaquierTable of contents Preamble Legacy situation Newest methods to estimate indexes size Index rebuild candidates list To go further Rebuild or shrink ? References Read more Oracle SQL, Tuning 3 comments
AWR mining for performance trend analysis Posted on January 20, 2018 , Modified on October 21, 2026 , by Yannick JaquierTable of contents Preamble Parallel downgrades Unstable execution time Direct path Checkpoint AWR figures extract and load References Read more Oracle Automatic Workload Repository (AWR), Tuning Leave a comment
Oracle Disk Manager (ODM) successful implementation Posted on December 20, 2017 , Modified on October 21, 2026 , by Yannick JaquierTable of contents Preamble Analysis Conclusion References Read more Oracle Tuning 4 comments
Automatic extended statistics to improve performance Posted on April 6, 2017 , Modified on October 14, 2026 , by Yannick JaquierTable of contents Preamble Automatic extended statistics preparation Automatic extended statistics testing References Read more Oracle SQL, Tuning 2 comments
PL/SQL performance tuning with bulk SQL/binding and parallelism Posted on February 14, 2017 , Modified on October 27, 2026 , by Yannick JaquierTable of contents Preamble Setup Classical method Bulk SQL method DBMS_PARALLEL_EXECUTE method Raw results References Read more Oracle PL/SQL, Tuning 8 comments