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
4. Select Ending Snapshot Go to time -> Click Go -> Click Ok
Now, you will be seeing on the screen "Processing View report....."
This how you will get the AUTOMATIC WORKLOAD REPOSITORY report for your Database
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
5 comments:
Thank you for the posting. You answered my question.
Thanks
could you please tell where the generated report is get stored?
Yes, you can click on 'Save to File' for storing the report. It will ask you to path.
Post a Comment