Oracle ADDM, AWR, ASH Reports

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.sql

To generate an ASH report on a specific database instance using the command-line interface:

@$ORACLE_HOME/rdbms/admin/ashrpti.sql

To 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.sql

To generate an ASH report on a specific database instance using the command-line interface:

@$ORACLE_HOME/rdbms/admin/ashrpti.sql

To 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.sql

To generate an ASH report on a specific database instance using the command-line interface:

@$ORACLE_HOME/rdbms/admin/ashrpti.sql

To generate an ASH report for Oracle RAC:

@$ORACLE_HOME/rdbms/admin/ashrpti.sql

Also see Using ADDM AWR ASH Reports:

AWR Report Analysis and ASH Report Analysis