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 . | 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 by both. By analyzing the information that is stored in the AWR, the database can identify the need to perform routine maintenance tasks, such as performing regular backups to maximize availability or refreshing statistics, which are used to optimize the execution of SQL statements. For problems that cannot be resolved automatically and require administrators to be notified (such as running out of space), the Oracle database provides server-generated alerts. The Oracle database can monitor itself and send out alerts to notify you of any problem. The alerts not only notify you of the problem, they also provide recommendations on how the reported problem can be resolved. Recommendations are generated from a number of advisors, each of which is responsible for a subsystem. For example, there are memory and SQL advisors. Introducing Terminology Automatic Workload Repository (AWR): Infrastructure for data gathering, analysis, and solutions recommendations Baseline: Data gathered of a “normal
