Using Database Advisors

Overview

Advisors are powerful tools that provide specific advice on how to address key database management challenges, covering a wide range of areas, including space, performance, and undo management. Advisors are built around two infrastructure components: Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM). This paper focuses on some of the database advisors that are invoked by ADDM to help one improve database performance. It presents sample questions of the type one may encounter when taking the Oracle Database 11g Administration Workshop I exam, which enables one to earn the Oracle Certified Associate level of certification.