Versions Compared

Old Version 1

changes.mady.by.user Former user

Saved on

compared with

New Version 2

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. In System Management Center, click Diagnostics in the left navigation and click Queries.
  2. Click Start Snapshot on the ribbon.
    Image Added
  3. Click OK in the Status dialog box.
    Image Added
  4. Click the End Snapshot button.
    Image Added
  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 Added
  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.NOTE Note: The AWR HTLM report cannot be exported to Excel. 
    Image Added
  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 Added
  8. To return to the Queries workspace, click the Queries bottom tab.

...