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 ...
Get OCA: Oracle 10g™ Administration I: Study Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
