SQL Access Advisor and SQL Tuning Advisor in 11gR2 Posted on November 26, 2015 , Modified on October 27, 2026 , by Yannick JaquierTable of contents Preamble SQL Tuning Set (STS) SQl Tuning Advisor (STA) SQL Access Advisor (SAA) Conclusion Read more Oracle SQL Access Advisor (SAA), SQL Tuning Advisor (STA) Leave a comment
Automatic SQL Tuning task overview Posted on October 31, 2012 , Modified on May 28, 2019 , by Yannick JaquierTable of contents Preamble Automated tasks With command lines With Cloud Control References Read more Oracle SQL Tuning Advisor (STA) 7 comments
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
SQL Access Advisor versus SQL Tuning Advisor Posted on October 28, 2011 , Modified on October 27, 2026 , by Yannick JaquierTable of contents Preamble SQL Access Advisor SQL Tuning Set Workload and task Result SQL Tuning Advisor Task Result Conclusion References Read more Oracle SQL Access Advisor (SAA), SQL Tuning Advisor (STA), SQL Tuning Set (STS) 6 comments
DBMS_SQLTUNE concrete example Posted on September 30, 2011 , Modified on May 28, 2019 , by Yannick JaquierTable of contents Preamble Tuning task DBMS_SQLTUNE result With Grid Control Read more Oracle SQL Profile, SQL Tuning Advisor (STA), Tuning 5 comments