mm

This is Vinod Kumar having 15+ years of experience as Oracle DBA having exposure to RAC, Dataguard, RMAN,GoldenGate, DB Upgrades ,Hadoop. Looking forward to sharpen my skill set and adapt new things. Worked for various industries like Banking, financial, Telecom, Product based companies and retail etc.

Share this post

Generating Oracle AWR reports on RAC and Non RAC DB’s

in Oracle DB Admin, Performance Tuning
Share via:
Post Views: 0

AWR Difference Report for NON RAC:

@?/rdbms/admin/awrddrpt.sql

AWR Difference Report for RAC :

@?/rdbms/admin/awrddrpi.sql

AWR Report for Non RAC :

@?/rdbms/admin/awrrpt

AWR Report for RAC :

@?/rdbms/admin/awrrpti

Global AWR RAC Report :

@?/rdbms/admin/awrgrpt.sql

ASH Report :

@?/rdbms/admin/ashrpt.sql

GLOBAL AWR RAC Differenct Report :

@?/rdbms/admin/awrgdrpt.sql

AWR Report for Single Select Statement :

@?/rdbms/admin/awrsqrpt.sql

ADDM Report :

@?/rdbms/admin/addmrpt

 

Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (12 votes, average: 5.00 out of 5)
Loading...

You might also like...

One thought on “Generating Oracle AWR reports on RAC and Non RAC DB’s”

Add Comment