Automatic Database Diagnostic Monitor (ADDM)

Automatic Database Diagnostic Monitor (ADDM) analyzes the data in Automatic Workload Repository (AWR) and provides options to resolve performance problems.

As AWR is a repository of historical performance data, ADDM analyzes the performance problems after the diagnosis, thus saving time and resources required to reproduce the problem.

Benefits of ADDM

  • Performs time-based quantification of application problems

  • Identifies the root causes of performance problems

  • Provides recommendations for fixing the problems

  • Identifies the nonproblem areas of the application

  • Helps you create and run ADDM tasks to analyze the current or past performance

Besides production systems, you can also use ADDM on development and test systems to find early warnings of application performance problems.

For more information about how to use ADDM, see: