Less_15ProactiveMaintenance.pptVIP

Proactive Maintenance Objectives After completing this lesson you should be able to do the following: Set warning and critical alert thresholds Collect and use baseline metrics Use tuning and diagnostic advisors Use the Automatic Database Diagnostic Monitor ADDM Manage the Automatic Workload Repository Server Generated Alerts Thresholds Each metric can be assigned two thresholds: Warning Critical When thresholds are reached, alerts are triggered by: Notifications that appear in the Alerts region of the Database Control home page Optional e-mail alerts Setting Thresholds Enterprise Manager’s Manage Metrics property page provides access to threshold settings. Baseline Measurements Using Baselines Tuning and Diagnostic Advisors Oracle Database 10g provides several tuning and diagnostic advisors: Automatic Database Diagnostic Monitor ADDM SQL Tuning and Access Advisors Memory Advisor Mean-Time-To-Recover MTTR Advisor Segment Advisor Undo Management Advisor Tuning and Diagnostic AdvisorsFull Notes Page SQL Tuning and Access Advisors Memory Advisors Shared pool Database buffer cache Program Global Area PGA Segment Advisor Entire tablespace Individual schema objects Automatic Workload Repository AWR Built-in repository of performance information Snapshots of database metrics are taken every 60 minutes and retained for 7 days Foundation for all self-management functions Managing the AWR Retention period Default 7 days Consider storage needs Collection interval Default 30 minutes Consider storage needs, performance impact Collection level Basic disables most of ADDM functionality Typical recommended All adds additional SQL tuning information to snapshots Automatic Database Diagnostic Monitor  ADDM Runs after each AWR snapshot Monitors the instance and detects bottlenecks Results stored within the AWR ADDM Findings ADDM Recommendations Summary In this lesson you should have learned how to: Set warning and critical alert thr