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

1
2
3

SQL> @$ORACLE_HOME/rdbms/admin/awrrpt.sql

SQL> @$ORACLE_HOME/rdbms/admin/awrrpti.sql