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.
Steps to Generate AWR Report in oracle :
Step 1 :
Go to $ORACLE_HOME/rdbms/admin location and you will see awrrpt.sql file is there.
cd $ORACLE_HOME/rdbms/admin
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!!
Pingback: How to check retention period of AWR in oracle
Pingback: Run SQL Tuning Advisor for a sql_id in Oracle : Easy Guide