Wednesday, May 09, 2012

How to generate AWR Report from OEM Grid

 

1. Choose the Database for which, AWR report to be generated

2. Choose Performance -> Snaphosts -> Automatic Workload Repository -> Run AWR Report

3. Select Beginning Snapshot, Go to time  -> Click Go -> Click Ok

image

4. Select Ending Snapshot   Go to time -> Click Go -> Click Ok


Now, you will be seeing on the screen "Processing View report....."

image

This how you will get the AUTOMATIC WORKLOAD REPOSITORY report for your Database
image

If you are looking to find SQL ID in past consumed much of the resource or caused performance issues, use Performance –> Top Activity –> Historical View , chose the time frame

image