Generating Compare Period Reports Using Enterprise Manager

This section describes how to generate compare period reports using Oracle Enterprise Manager.

To generate compare period reports using Enterprise Manager:

1. On the Software and Support page, under Real Application Testing, click Database Replay.

   The Database Replay page appears.

2. In the Go to Task column, click the icon that corresponds to the Replay Workload task.

   The Replay Workload page appears.

3. In the Directory Object list, select the directory that contains the replayed workload for which you want to generate a compare period report.

   After the directory is selected, the Replay Workload page will be refreshed to display the Capture Summary and the Replay History sections.

4. The Replay History section displays previous replays of the workload capture. Select the replay for which you want to generate a compare period report and click View.

   The View Workload Replay page appears.

5. Click the Report tab.

6. Under Compare Period Report, select the first and second workload captures or replays you want to compare.

7. To generate a:

   • Replay Compare Period report, click Run Replay Compare Period Report.

     Use the replay compare period report to perform a high-level comparison of one workload replay to its capture or to another replay of the same capture. Only workload replays that contain at least 5 minutes of database time can be compared using this report.

     For information about how to interpret the replay compare period report, see "Reviewing Replay Compare Period Reports".

   • AWR Compare Period report, click Run AWR Compare Period Report.

     Use the AWR compare period report to compare the AWR data from one workload replay to its capture or to another replay of the same capture.

     For information about how to interpret AWR compare period reports, see Summary of the AWR Compare Periods Report.

   • SQL Performance Analyzer report, click Run SQL Performance Analyzer Report, then Yes to submit a scheduler job.

     Use the SQL Performance Analyzer report to compare a SQL tuning set from a workload capture to another SQL tuning set from a workload replay, or two SQL tuning sets from two workload replays.

     For information about how to interpret the SQL Performance Analyzer report, see "Reviewing the SQL Performance Analyzer Report Using Oracle Enterprise Manager".

   The Report window opens while the report is being generated. Once the report is generated, you can save the report by clicking Save to File.