Skip to content

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