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 existing snapshots must be available.

To compare performance using two pairs of snapshots: 

1. From the Database Home page, click Server.

   The Server page appears.

2. Under Statistics Management, click Automatic Workload Repository.

   The Automatic Workload Repository page appears.

3. Under Manage Snapshots and Baselines, click the link next to Snapshots.

   The Snapshots page appears.

4. From the Go To Time list, select the time for the starting snapshot and then click Go.

5. Under Select Beginning Snapshot, select the starting point for the first snapshot period to be included in the report.

6. From the Actions list, select Compare Periods and click Go.

   The Compare Periods: First Period End page appears.

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

   The Compare Periods: Second Period Start page appears.

8. Select the starting point for the second snapshot period to be included in the report and click Next. This snapshot is the third of four.

   The Compare Periods: Second Period End page appears.

9. Select the end point for the second period that will be included in the report and click Next.

   The Compare Periods: Review page appears.

10. Review the selected periods to be included in the report and then click Finish.

    The Compare Periods: Results page appears.

    Data from the selected periods appears under the General subpage. You can view data per second or per transaction by selecting an option from the View Data list.

11. To view the report, click the Report tab.

    The Processing: View Report page appears while the report is being generated. After it completes, the report will appear.

12. Optionally, do the following:

    • To change periods, click Change Periods.

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