Oracle – AWR, ASH and ADDM reports for RAC or Non Rac Database
Following are the scripts that can be executed as sysdba in order to get the AWR, ASH and ADDM reports on Oracle RAC:
SQL script for getting AWR Report on RAC database:
SQL script for getting AWR Report for single instance:
SQL script for getting ASH Report on RAC database:
SQL script for getting ASH Report for single Instance:
SQL script for getting ADDM Report on RAC database:
SQL script for getting ADDM Report for single instance:
SQL>@$ORACLE_HOME/rdbms/admin/awrgrpt.sqlSQL script for getting AWR Report for single instance:
SQL>@$ORACLE_HOME/rdbms/admin/awrrpt.sqlSQL script for getting ASH Report on RAC database:
SQL>@$ORACLE_HOME/rdbms/admin/ashrpti.sqlSQL script for getting ASH Report for single Instance:
SQL>@$ORACLE_HOME/rdbms/admin/ashrpt.sqlSQL script for getting ADDM Report on RAC database:
SQL>@$ORACLE_HOME/rdbms/admin/addmrpti.sqlSQL script for getting ADDM Report for single instance:
SQL>@$ORACLE_HOME/rdbms/admin/addmrpt.sql
No comments:
Post a Comment