The Automatic Workload Repository (AWR) collects and maintains statistics of the database.

We can generate awr report for a particular time frame in the past using the script awrrpt.sql ( located under $ORACLE_HOME/rdbms/admin)

script – @$ORACLE_HOME/rdbms/admin/awrrpt.sql

For rac databases, the script awrrpt.sql script need to be run again each instance.

 

For NON-SYSDBA USERS, BELOW GRANTS ARE REQUIRED TO GENERATE AWR REPORT: