Creating an Analysis Task Using Enterprise Manager

There are 5 types of workflow available in Oracle Enterprise Manager for creating a SQL Performance Analyzer task:

• Upgrade from 9i or 10.1

  Use the upgrade from 9i or 10.1 workflow to test a database upgrade from Oracle9i Database or Oracle Database 10g Release 1 to Oracle Database 10g Release 2 and newer releases, as described in "Upgrading from Oracle9i Database and Oracle Database 10g Release 1".

• Upgrade from 10.2 or 11g

  Use the upgrade from 10.2 or 11g workflow to test a database upgrade from Oracle Database 10g Release 2 or Oracle Database 11g to a later release, as described in "Upgrading from Oracle Database 10g Release 2 and Newer Releases".

• Parameter Change

  Use the parameter change workflow to determine how a database initialization parameter change will affect SQL performance, as described in "Using the Parameter Change Workflow".

• Exadata Simulation

  Use the Exadata simulation workflow to simulate how using Oracle Exadata will affect SQL performance, as described in "Using the Exadata Simulation Workflow".

• Guided workflow

  Use the guided workflow to compare SQL performance for all types of system changes other than a database initialization parameter change, as described in "Using the Guided Workflow".