Page Comparison

To create an Oracle snapshot:

1. In System Management Center, click Diagnostics in the left navigation and click Queries.
2. Click Start Snapshot on the ribbon.
   Image Modified
3. Click OK in the Status dialog box.
   Image Modified
4. Click the End Snapshot button.
   Image Modified
5. Review the available snapshot reports displayed in the left pane. The Oracle AWR HTML Report by Snapshot ID Range is displayed by default in the right pane. To save the AWR HTML report, click the Save to Local Disk button.
   Image Modified

6. To generate the Top 8 SQL ID report, click Oracle - Reports for Top 8 SQL ID by Elapsed Time under Queries and review the results in the right pane. To export snapshot reports to Excel, click the Export All button.

   Info
   title Note
   The AWR HTLM report cannot be exported to Excel.

   Image Modified

7. To generate the Sessions report, click Oracle - Sessions Report by AWR under Queries and review the results in the right pane. Click the browse button in the right pane to open the Cell content dialog box to view the details.
   Image Modified
8. To return to the Queries workspace, click the Queries bottom tab.

back to top