First page Back Continue Last page Graphics
…AWR Reporting
Enterprise Manager or awrrpt.sql’ script
Creates “Workload Repository Report”
- “statspack-like” report
- You specify range of snapshots
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_”.