• ADDM - Automatic Database Diagnostic Monitor
   

• All dbms_advisor package with ADDM as the value to the advisor_name parameter.
   

• The addmrpt.sql and addmrpti.sql reports.

Views starting with dba_advisor_* of all tasks generated by ADDM (i.e. tasks with ADDM as the advisor_name column in dba_advisor_tasks view).

The Database Tuning Pack is required to access the SQL Tuning Advisor PL/SQL packages located in $ORACLE_HOME/rdbms/admin. These packages include: dbms_advisor package with SQL Tuning Advisor as the value to the advisor_name parameter and dbms_sqltune package.

Conclusion

This chapter discussed the Automatic Workload Repository and Automatic Diagnostic Monitor. The AWR architecture, Active Session History (ASH), server Generated Alerts, and ADDM performance monitoring were explored. The following information was covered:

• AWR provides services to the database to access, collect, process, and maintain performance statistics on various database functionalities.
   

• AWR snapshots are taken every hour and kept in the repository for seven days by default.
   

• Oracle Database 10g invokes server generated alerts automatically to inform about performance or resource issues and when an alert situation is cleared.]
   

• dba_alert_history table and alert_que retain the alert information which is periodically purged.
   

• ADDM does a top-down analysis of the database, identifies problems and potential issues, and gives recommendations for fixing these problems.
   

• OEM can be used to keep a visual track of all database health and functionality issues.

This concludes the initial review and analysis of AWR and ADDM and the Oracle Database 10g manageability infrastructure. The next topic to explore is storage enhancements. Information about Automatic Storage Management (ASM) concepts will be presented in the following chapter.