How To Generate AWR Report In RAC
In this blog , we will see how to generate AWR Report in RAC.
AWR report can be generating in RAC database using 2 scripts awrrpt.sql or awrrpti.sql
awrrpt.sql – This will generate the one report for the database across all the nodes(i.e for all instances) for a partiular snapshot range.
awrrpti.sql – This will genereate report for a particular instance, i.e for a 2 node RAC database , there will be two reports( one for each instance
USING AWRRPT.SQL SCRIPT:
SQL> @$ORACLE_HOME/rdbms/admin/awrrpt.sql
USING AWRRPTI.SQL SCRIPT:
This script will prompt for providing the instance number :
SQL> @$ORACLE_HOME/rdbms/admin/awrrpti.sql
