Guenadi N Jilevski's Oracle BLOG

Oracle RAC, DG, EBS, DR and HA DBA BLOG

Using PL/SQL to run the SQL tuning Advisor in 11gR2

Using PL/SQL to run the SQL tuning Advisor in 11gR2

In the article we will have a look at the steps to invoke and run the SQL Tuning Advisor using the interface of the PL/SQL packages provided by Oracle. The SQL Tuning Advisor can be run in an alternative way using the OEM 12c Cloud Control interface. We will not cover the OEM 12c CC interface.

Continue reading

May 7, 2016 Posted by | oracle | Leave a comment