How To Generate ADDM Report in Oracle Database?

by

To generate ADDM Report in an Oracle database. It’s simple and very easy, please follow the below steps.

  • ADDM analyzes the AWR report to identify performance bottlenecks.
  • ADDM analyzes the actual root cause and provides the recommendations.
  • If you have generated an AWR report, then an ADDM report is also generated inside the AWR report.
  • The STATISTICS_LEVEL parameter is to set ALL or TYPICAL.
  • ADDM automatically detects and provides the best recommendations.

Full form of ADDM report:

Automatic Database Diagnostic Monitor (ADDM).

Just go to this below location:
$ORACLE_HOME/rdbms/admin

Remember: There are two types of formats to generate reports.

  1. Text format.
  2. HTML format.

Choose any format of ADDM report.

To generate ADDM Report execute the below query and follow the instructions.
@$ORACLE_HOME/rdbms/admin/addmrpt.sql

Leave a Comment