Overview of Automatic Database Diagnostic Monitor

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 then does the following:

• Locates the root causes of the performance problems

• Provides recommendations for correcting them

• Quantifies the expected benefits

• Identifies areas where no action is necessary.

This section contains the following topics:

• ADDM Analysis

• ADDM Recommendations

• ADDM for Oracle Real Application Clusters

• ADDM for a Multitenant Environment