OCA: Oracle Database 11g Administrator Certified Associate Study Guide- P19: There is high demand for professionals in the information technology (IT) industry, and Oracle certifications are the hottest credential in the database world. You have made the right decision to pursue certification, because being Oracle Database 11g certified will give you a distinct advantage in this highly competitive market. | Exam Essentials 831 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 via email whenever a monitored event occurs in the database. Remember the location of alert log file. Starting in Oracle 11g the alert log file location is determined by the DIAGNOSTIC_DEST parameter. Learn the location of the text alert log file and XML alert log file. 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 Automatic Memory Management. Know the parameters that control the memory management and how the pools are allocated. Understand sources of tuning information. Know in which dynamic performance views data dictionary views and log files tuning information can be found outside the EM Database Control monitoring system. 832 Chapter 14 Maintaining the Database and Managing Performance Review Questions 1. Which of the following components of the Oracle architecture stores the statistics gathered by the MMON process A. ADDM B. AWR C. ASMM D. ADR 2. Which of the following options for the pfile spfile s STATISTICS_LEVEL parameter turns off AWR statistics gathering and ADDM advisory services A. OFF B. TYPICAL C. ALL D. BASIC 3. Which parameter is used to enable .
