Automatic Database Diagnostic Monitor (ADDM)
The Automatic Database Diagnostic Monitor (ADDM) tab includes controls to access the information stored by ADDM.
ADDM analyzes the Automatic Workload Repository (AWR) data regularly, then locates the root causes of performance problems, provides recommendations for correcting any problems, and identifies non-problem areas of the application. Because AWR is a repository of historical performance data, ADDM can be used to analyze performance issues after the event, often saving time and resources that would be needed to reproduce a problem.
ADDM provides the following benefits:
-
Time-based quantification of application problem impacts and recommendation benefits
-
Provides recommendations for treating the root causes of problems
-
Identification of non-problem areas of the application
-
Allows users to create and run an ADDM task to analyze current or past performance
In addition to the benefits ADDM provides for production systems, it can be used on development and test systems to provide early warnings of application performance issues.