Using ADDM AWR ASH Reports. ADDM is diagnostic software built into Oracle Database. ADDM examines and analyzes data captured in Automatic Workload Repository (AWR) to determine possible database performance problems.
- ADDM Report
Automatic Database Diagnostic Monitor(ADDM) can analyze performance issues during a particular period and provide suggestion. An ADDM analysis is performed on a set of AWR snapshots. addmrpt.sql script is used to generate addm report.
Generate ADDM report:
cd $ORACLE_HOME/rdbms/admin
SQL> @addmrpt.sql- AWR Report
Oracle provide two scripts to produce workload repository reports (awrrpt.sql and awrrpti.sql). They are similar in format to the statspack reports and give the option of HTML or plain text formats. The two reports give essential the same output but the awrrpti.sql allows you to select a single instance. The reports can be generated as follows.
@$ORACLE_HOME/rdbms/admin/awrrpt.sql
@$ORACLE_HOME/rdbms/admin/awrrpti.sql- ASH Report
To generate an ASH report on the local database instance using the command-line interface:
@$ORACLE_HOME/rdbms/admin/ashrpt.sqlTo generate an ASH report on a specific database instance using the command-line interface:
@$ORACLE_HOME/rdbms/admin/ashrpti.sqlTo generate an ASH report for Oracle RAC:
@$ORACLE_HOME/rdbms/admin/ashrpti.sql- ADDM Report
Automatic Database Diagnostic Monitor(ADDM) can analyze performance issues during a particular period and provide suggestion. An ADDM analysis is performed on a set of awr snapshots. addmrpt.sql script is used to generate addm report.
Generate ADDM report:
cd $ORACLE_HOME/rdbms/admin
SQL> @addmrpt.sql- AWR Report
Oracle provide two scripts to produce workload repository reports (awrrpt.sql and awrrpti.sql). They are similar in format to the statspack reports and give the option of HTML or plain text formats. The two reports give essential the same output but the awrrpti.sql allows you to select a single instance. The reports can be generated as follows.
@$ORACLE_HOME/rdbms/admin/awrrpt.sql
@$ORACLE_HOME/rdbms/admin/awrrpti.sql- ASH Report
To generate an ASH report on the local database instance using the command-line interface:
@$ORACLE_HOME/rdbms/admin/ashrpt.sqlTo generate an ASH report on a specific database instance using the command-line interface:
@$ORACLE_HOME/rdbms/admin/ashrpti.sqlTo generate an ASH report for Oracle RAC:
@$ORACLE_HOME/rdbms/admin/ashrpti.sql- ADDM Report
Automatic Database Diagnostic Monitor(ADDM) can analyze performance issues during a particular period and provide suggestion. An ADDM analysis is performed on a set of awr snapshots. addmrpt.sql script is used to generate addm report.
Generate ADDM report:
cd $ORACLE_HOME/rdbms/admin
SQL> @addmrpt.sql- AWR Report
Oracle provide two scripts to produce workload repository reports (awrrpt.sql and awrrpti.sql). They are similar in format to the statspack reports and give the option of HTML or plain text formats. The two reports give essential the same output but the awrrpti.sql allows you to select a single instance. The reports can be generated as follows.
@$ORACLE_HOME/rdbms/admin/awrrpt.sql
@$ORACLE_HOME/rdbms/admin/awrrpti.sql- ASH Report
To generate an ASH report on the local database instance using the command-line interface:
@$ORACLE_HOME/rdbms/admin/ashrpt.sqlTo generate an ASH report on a specific database instance using the command-line interface:
@$ORACLE_HOME/rdbms/admin/ashrpti.sqlTo generate an ASH report for Oracle RAC:
@$ORACLE_HOME/rdbms/admin/ashrpti.sqlAlso see Using ADDM AWR ASH Reports: