3 Automatic Database Performance Monitoring

Automatic Database Diagnostic Monitor (ADDM) automatically detects and reports performance problems with the database. The results are displayed as ADDM findings on the Database Home page in Oracle Enterprise Manager Cloud Control (Cloud Control). Reviewing the ADDM findings enables you to quickly identify the performance problems that require your attention. Before using another performance tuning method described in this guide, first review the results of the ADDM analysis.

Each ADDM finding provides a list of recommendations for reducing the impact of the performance problem. You should review ADDM findings and implement the recommendations every day as part of regular database maintenance. Even when the database is operating at an optimal performance level, you should continue to use ADDM to monitor database performance on an ongoing basis.

This chapter contains the following sections:

• Overview of Automatic Database Diagnostic Monitor

• Configuring Automatic Database Diagnostic Monitor

• Reviewing the Automatic Database Diagnostic Monitor Analysis

• Interpretation of Automatic Database Diagnostic Monitor Findings

• Implementing Automatic Database Diagnostic Monitor Recommendations

• Viewing Snapshot Statistics

See Also:

• Oracle Database Performance Tuning Guide for information about using the DBMS_ADVISOR package to diagnose and tune the database with the Automatic Database Diagnostic Monitor