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
How to submit an external script with Oracle scheduler Posted on October 25, 2016 , Modified on October 25, 2016 , by Yannick JaquierTable of contents Preamble Oracle scheduler external job References Read more Oracle Administration, SQL 4 comments
Incremental statistics on partitioned tables Posted on June 29, 2016 , Modified on June 29, 2016 , by Yannick JaquierTable of contents Preamble Incremental statistics Results References Read more Oracle SQL, Tuning 3 comments
Aggregated global statistics on partitioned tables or not ? Posted on June 1, 2016 , Modified on July 1, 2025 , by Yannick JaquierTable of contents Preamble Partitioned test table Aggregated global statistics Gathered global statistics Global statistics performance comparison References Read more Oracle SQL, Tuning 1 comment
System statistics interaction with database resource manager Posted on May 2, 2016 , Modified on May 2, 2018 , by Yannick JaquierTable of contents Preamble Optimizer differences System statistics References Read more Oracle Database Resource Manager (DBRM), SQL, Tuning Leave a comment
Concurrent statistics activation and gathering Posted on February 3, 2016 , Modified on July 23, 2024 , by Yannick JaquierTable of contents Preamble Traditional statistics gathering Concurrent statistics testing References Read more Oracle SQL, Tuning Leave a comment