SQL Access Advisor and SQL Tuning Advisor in 11gR2 Posted on November 26, 2015, updated on November 26, 2015 by Yannick JaquierTable of contents Preamble SQL Tuning Set (STS) SQl Tuning Advisor (STA) SQL Access Advisor (SAA) Conclusion Continue reading
Data Warehouse performance features implementation Posted on September 23, 2015, updated on May 2, 2018 by Yannick JaquierTable of contents Preamble Data Warehouse test case Star Transformation Enabled Bitmap Join Index Automatic parallelism References Continue reading
Cardinality feedback to automatically improve query plans Posted on February 5, 2015, updated on July 23, 2024 by Yannick JaquierTable of contents Preamble Cardinality feedback configuration Cardinality feedback testing References Continue reading
New 11gR2 relink command Posted on December 10, 2012, updated on January 26, 2016 by Yannick JaquierTable of contents Preamble Solutions Dedicated oraInst.loc file Overwrite oraInst.loc with variables References Continue reading
Deferred statistics publishing Posted on February 4, 2011, updated on June 25, 2015 by Yannick JaquierTable of contents Preamble Test table Deferred statistics testing Continue reading
Server result cache to improve performance by holding result sets Posted on January 21, 2011, updated on May 2, 2018 by Yannick JaquierTable of contents Preamble Server result cache Manual mode Force mode Table annotations PL/SQL function result cache Client result cache References Continue reading