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:
-
Reviewing the Automatic Database Diagnostic Monitor Analysis
-
Interpretation of Automatic Database Diagnostic Monitor Findings
-
Implementing Automatic Database Diagnostic Monitor Recommendations
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