Real-time SQL Plan Management hands-on Posted on October 15, 2026 , Modified on October 1, 2026 , by Yannick JaquierTable of contents Preamble Real-time SQL Plan Management setup Real-time SQL Plan Management test case Table creation Perfect world situation Someone has (wrongly) gathered statistics on a table References Read more Oracle Automatic SQL Plan Management (ASPM), Real-time SQL Plan Management, SQL Plan Management (SPM) Leave a comment
Automatic SQL Plan Management (ASPM) hands-on Posted on December 30, 2024 , Modified on July 13, 2026 , by Yannick JaquierTable of contents Preamble Automatic SQL Plan Management (ASPM) setup Automatic SQL Plan Management (ASPM) test case We live in a peaceful world (so far) Who has messed up ? Automatic SPM to the rescue References Read more Oracle Automatic SQL Plan Management (ASPM), SQL Plan Management (SPM) 1 comment
SQL Plan Management Posted on December 22, 2011 , Modified on January 23, 2026 , by Yannick JaquierTable of contents Preamble Testing Testing with Adaptive Cursor Sharing (ACS) Testing with SQL Profile Link between sql_id and SQL Plan Baselines Conclusion References Read more Oracle Adaptive Cursor Sharing (ACS), SQL Plan Management (SPM), SQL Tuning Advisor (STA) 2 comments