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

at

5 comments:

  1. Unknown8:50 PM

    Thank you for the posting. You answered my question.

    ReplyDelete
  2. Unknown12:23 AM

    Thanks

    ReplyDelete
  3. Unknown12:23 AM

    This comment has been removed by the author.

    ReplyDelete
  4. Unknown3:08 AM

    could you please tell where the generated report is get stored?

    ReplyDelete
  5. Nivritti Suste6:34 AM

    Yes, you can click on 'Save to File' for storing the report. It will ask you to path.

    ReplyDelete