oracledba.help
TroubleShooting

Automatic Database Diagnostic Monitor (ADDM)

Overview

ADDM can analyze performance issues after the event. Oracle feels ADDM should be the first tool used to analyze a performance problem. ADDM provides the following benefits:

ADDM details:

  • Problem diagnosis and areas impacted.
  • Identification of root cause and recommendations to fix.
  • Identification of non-problem areas of the system.

Example Report Creation Session

SQLPLUS> @$ORACLE_HOME/rdbms/admin/addmrpt.sql

Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 10165

Enter value for end_snap: 10171

Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is addmrpt_2_10165_10171.txt.  To use this name,
press <return> to continue, otherwise enter an alternative.

Enter value for report_name: <ENTER>

Report runs...

End of Report
Report written to addmrpt_4_10165_10171.txt