DBA Hub

📋Steps in this guide1/1

How To Generate AWR Report In RAC

In this blog , we will see how to generate AWR Report in RAC.

oracle configurationintermediate
by OracleDba
15 views
1

Overview

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

Code/Command (click line numbers to comment):

1
2
3
SQL> @$ORACLE_HOME/rdbms/admin/awrrpt.sql

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

Comments (0)

Please to add comments

No comments yet. Be the first to comment!