9.4. Exam Essentials

Understand the Automatic Workload Repository. Describe the components of the AWR and how they are used to collect and store database performance statistics.

Describe the role of Automatic Database Diagnostic Monitor. Know how ADDM uses the AWR statistics to formulate tuning recommendations using historical and baseline metrics.

Explain how each advisor is used to improve performance. Describe how you can use each of the EM Database Control advisors shown on the Advisor Central screen to improve database performance and manageability.

Describe how alerts are used to monitor performance. Show how you can configure the EM Database Control alert system to alert you via the console or e-mail whenever a monitored event occurs in the database.

Identify and fix invalid or unusable objects. Understand the techniques you can use to identify invalid procedures, functions, triggers, and views and how to validate them. Know how to find unusable indexes and how to fix them.

Understand sources of tuning information. Know in which dynamic performance views, data dictionary views, and log files tuning information can be found.