Your browser does not support JavaScript. This help page requires JavaScript to render correctly.
Skip Headers
Previous
Previous
 
Next
Next

Reviewing the SQL Performance Analyzer Report Using Oracle Enterprise Manager

When a SQL Performance Analyzer task is completed, the resulting data is generated into a SQL Performance Analyzer report that compares the pre-change and post-change SQL performance.

Tip: Before you can view the SQL Performance Analyzer report, compare the pre-change version of performance data with the post-change version, as described in "Comparing SQL Trials Using Oracle Enterprise Manager"

To generate and review the SQL Performance Analyzer report:

  1. On the Software and Support page, under Real Application Testing, click SQL Performance Analyzer.

    The SQL Performance Analyzer page appears. A list of existing SQL Performance Analyzer tasks are displayed.

  2. Under SQL Performance Analyzer Tasks, select the task for which you want to view a SQL Performance Analyzer report and click View Latest Report.

    The SQL Performance Analyzer Task Report page appears.

  3. Review the general information about the performance analysis, as described in "Reviewing the SQL Performance Analyzer Report: General Information".

  4. Review general statistics, as described in "Reviewing the SQL Performance Analyzer Report: Global Statistics".

  5. Optionally, review the detailed statistics, as described in "Reviewing the SQL Performance Analyzer Report: Global Statistics Details".

Related Topics

Comparing SQL Trials Using Oracle Enterprise Manager