Blog

You should know at first what is AWR Report. So, AWR stands for Automatic Workload Repository. AWR is a performance Report which collects the data of Oracle database in regular interval and maintains performance statistics and helps us to troubleshoot for any performance issue in Oracle Database. We can generate the AWR Report for Standalone as well as RAC instance. Lets go through the steps how to generate AWR Report in Oracle for Standalone database.

Step 1 :

Go to $ORACLE_HOME/rdbms/admin location and you will see awrrpt.sql file is there.

Step 2:

Login to Oracle database.

Step 3 :

Run this awrrpt.sql sql file and you will be asked to select the format, instance number and number of days you want to see. Here we have put 3.

Step 4:

Select the snap ids according to your required time interval, you will be able to get the Report.

We can also generate AWR Report from OEM also. You can follow the link for the same. Hope this helps!!