Hey,
You also always need to lookup for the right AWR Script to run, just like me?
Here is a quick summary that may help you (and myself) in future. 🙂
@?/rdbms/admin/awrrpt.sql --> basic AWR report @?/rdbms/admin/awrsqrpt.sql --> Standard SQL statement Report @?/rdbms/admin/awrddrpt.sql --> Period diff on current instance @?/rdbms/admin/awrrpti.sql --> Workload Repository Report Instance (RAC) @?/rdbms/admin/awrgrpt.sql --> AWR Global Report (RAC) @?/rdbms/admin/awrgdrpt.sql --> AWR Global Diff Report (RAC) @?/rdbms/admin/awrinfo.sql --> Script to output general AWR information
Hope it helps!
Cheers!