Viewing Snapshot Statistics

You can view the data contained in snapshots taken by AWR using Enterprise Manager. Typically, it is not necessary to review snapshot data because it primarily contains raw statistics. Instead, rely on ADDM, which analyzes statistics to identify performance problems. Snapshot statistics should be used primarily by advanced users, or by DBAs accustomed to using Statspack for performance analysis.

To view snapshot statistics: 

1. From the Database Home page, click Performance.

   The Performance page appears.

2. Under Additional Monitoring Links, click Snapshots.

   The Snapshots page appears with a list of the most recent snapshots.

3. To view the statistics gathered in a snapshot, click the ID link of the snapshot you want to view.

   The Snapshot Details appears, showing the Details subpage.

4. To view a Workload Repository report of the statistics, click Report.

   The Workload Repository report appears.

5. Optionally, click Save to File to save the report for later access.