List Essential Performance Reports Scritps

Today I like list (and remember in some case) the basics performance reports for the more powerfull utilities in Oracle, ASH, ADDM and AWR. I put where it is and if is for RAC or single instance.

AWR Single instance

STA @$ORACLE_HOME/rdbms/admin/awrrpt.sql

AWR RAC

STA @$ORACLE_HOME/rdbms/admin/awrgrpt.sql

 

ADDM Single instance

@STA $ORACLE_HOME/rdbms/admin/addmrpt.sql

ADDM RAC

@STA $ORACLE_HOME/rdbms/admin/addmrpti.sql

 

ASH Single instance

@STA $ORACLE_HOME/rdbms/admin/ashrpt.sql

ASH RAC

@STA $ORACLE_HOME/rdbms/admin/ashrpti.sql

HTH – Antonio NAVARRO

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s