TAILIEUCHUNG - Less12_ProactiveM_MB3

After completing this lesson, you should be able to do the following: • Use statistics • Manage the Automatic Workload Repository (AWR) • Use the Automatic Database Diagnostic Monitor (ADDM) • Describe the advisory framework • Set alert thresholds • Use server-generated alerts • Use automated tasks | Proactive Maintenance Objectives After completing this lesson, you should be able to do the following: Use statistics Manage the Automatic Workload Repository (AWR) Use the Automatic Database Diagnostic Monitor (ADDM) Describe the advisory framework Set alert thresholds Use server-generated alerts Use automated tasks Proactive Maintenance Automatic Workload Repository Server alerts Automated tasks Advisory framework Data warehouse of the database Automatic collection of important statistics Direct memory access Automatic Proactive Efficient Proactive Maintenance Proactive maintenance is made easy by the sophisticated infrastructure of the Oracle database. The main elements are as follows: The Automatic Workload Repository (AWR) is a built-in repository in each Oracle database. At regular intervals, the Oracle database makes a snapshot of all its vital statistics and workload information and stores them in the AWR. The captured data can be analyzed by you, by the database itself, or .

• Cơ sở dữ liệu
• workshopI
• oca 10g
• oracle
• database
• dba
• cơ sở dữ liệu
• công nghệ thông tin