How to non intrusively find index rebuild or shrink candidates ? Posted on November 23, 2018, updated on November 28, 2019 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 Continue reading
AWR mining for performance trend analysis Posted on January 20, 2018, updated on July 8, 2024 by Yannick JaquierTable of contents Preamble Parallel downgrades Unstable execution time Direct path Checkpoint AWR figures extract and load References Continue reading
Oracle Disk Manager (ODM) successful implementation Posted on December 20, 2017, updated on September 2, 2021 by Yannick JaquierTable of contents Preamble Analysis Conclusion References Continue reading
Automatic extended statistics to improve performance Posted on April 6, 2017, updated on July 9, 2024 by Yannick JaquierTable of contents Preamble Automatic extended statistics preparation Automatic extended statistics testing References Continue reading
PL/SQL performance tuning with bulk SQL/binding and parallelism Posted on February 14, 2017, updated on July 4, 2024 by Yannick JaquierTable of contents Preamble Setup Classical method Bulk SQL method DBMS_PARALLEL_EXECUTE method Raw results References Continue reading
Incremental statistics on partitioned tables Posted on June 29, 2016, updated on June 29, 2016 by Yannick JaquierTable of contents Preamble Incremental statistics Results References Continue reading