First page Back Continue Last page Graphics

…AWR Reporting


Notes:

Beyond just querying the repository, there are many supplied reports that can be created. OEM provides a graphical user interface to access these reports. Within Enterprise Manager, the AWR report is accessed with these steps:
Administration tab
Automatic Workload Repository link (near bottom of Administration screen)
Click on Snapshots link
Select Beginning Snapshop
Choose “View Report” in Actions drop-down
Select “Go”
Select Ending Snapshot
Click “Go”
Click “OK”
Or, use line-mode reports like shown in this slide.
Refer to Chapter 5 of the Oracle10g Database Performance Tuning Guide for more information on Oracle’s awrrpt.sql script and AWR in general. The sample scripts supplied with this course contain several AWR reports. Refer to the supplied scripts with the prefix “awrrpt_”.