TAILIEUCHUNG - OCA: Oracle Database 11g Administrator Certified Associate Study Guide- P19

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 .

TỪ KHÓA LIÊN QUAN
TAILIEUCHUNG - Chia sẻ tài liệu không giới hạn
Địa chỉ : 444 Hoang Hoa Tham, Hanoi, Viet Nam
Website : tailieuchung.com
Email : tailieuchung20@gmail.com
Tailieuchung.com là thư viện tài liệu trực tuyến, nơi chia sẽ trao đổi hàng triệu tài liệu như luận văn đồ án, sách, giáo trình, đề thi.
Chúng tôi không chịu trách nhiệm liên quan đến các vấn đề bản quyền nội dung tài liệu được thành viên tự nguyện đăng tải lên, nếu phát hiện thấy tài liệu xấu hoặc tài liệu có bản quyền xin hãy email cho chúng tôi.
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.