Tuning Regressed SQL Statements After Testing a Database Upgrade

In some cases, SQL Performance Analyzer may identify SQL statements whose performance regressed after you upgrade the database on the test system.

If you are upgrading from Oracle Database 10g and newer releases, you can tune the regressed SQL statements by using the SQL Tuning Advisor or SQL plan baselines, as described in Comparing SQL Trials.

If you are upgrading from Oracle 9i Database, you will need to use the DBMS_SQLTUNE package to tune the regressed SQL statements one at a time.