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
