SQL Performance Analyzer supports testing database upgrades from Oracle9i and later releases to Oracle Database 10g Release 2 or newer releases. The methodology used to test a database upgrade from Oracle9i Database and Oracle Database 10g Release 1 is slightly different from the one used to test a database upgrade from Oracle Database 10g Release 2 and later releases, so both methodologies are described here.
This chapter describes how to use SQL Performance Analyzer in a database upgrade and contains the following sections:
Upgrading from Oracle9i Database and Oracle Database 10g Release 1
Upgrading from Oracle Database 10g Release 2 and Newer Releases
Tuning Regressed SQL Statements After Testing a Database Upgrade
"SQL Performance Analyzer" for information about using SQL Performance Analyzer in other cases