Diagnosing Performance Problems Using ADDM

At times, database performance problems arise that require your diagnosis and correction. Usually, these problems are brought to your attention by Automatic Database Diagnostic Monitor (ADDM), which does a top-down system analysis every hour by default, and reports its most significant findings on the Database Home page.

This section contains the following topics:

• Viewing a Summary of ADDM Performance Findings

• Responding to ADDM Performance Findings

• Running ADDM Manually

• Modifying AWR Snapshot Frequency and Retention