Comparing Two Pairs of Snapshots

If an existing baseline is unavailable, then you can compare database performance by using two arbitrary pairs of snapshots. Use one pair taken when the database is performing optimally, and another pair when the database is performing poorly. At least four snapshots must be available.

To compare performance using two pairs of snapshots:

1. Access the Database Home page.

   See "Accessing the Database Home Page" for more information.

2. From the Performance drop-down menu, select AWR and then Compare Periods Reports.

   If the Database Login page appears, then log in as a user with administrator privileges. The Run Compare Periods Report page appears.

3. In First Period, select By Snapshot.

4. In Begin Snapshot, click the magnifying glass icon.

   The Search and Select: Snapshots page appears.

5. Select the starting point for the first snapshot period to be included in the report, and then click Select.

   You are returned to the Run Compare Periods Report page.

6. In End Snapshot, click the magnifying glass icon.

   The Search and Select: Snapshots page appears.

7. Select the ending point for the first snapshot period to be included in the report, and then click Select.

   You are returned to the Run Compare Periods Report page.

8. Under Second Period, repeat Step 3 through Step 7.

9. Click Generate Report.

   The Report Results section appears on the Run Compare Periods Report page. The section contains the Workload Repository Compare Period Report.

10. Optionally, do the following:

    • To change periods, repeat Step 3 through Step 9.

    • To save the report as an HTML file, click Save to File.