1 / 18

Proactive Maintenance

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)

swann
Télécharger la présentation

Proactive Maintenance

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Proactive Maintenance

  2. 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

  3. Server Generated Alerts Enterprise Manager Serveralertsqueue Oracle instance Metric exceeds threshold AWR

  4. ALERT 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

  5. Setting Thresholds • Enterprise Manager’s Manage Metrics property page provides access to threshold settings.

  6. Baseline Measurements • Baseline measurements provide threshold recommendations based on actual performance data.

  7. Using Baselines • To activate a stored baseline: 1. Click Copy Thresholds From Baseline. 2. Select the appropriate threshold.

  8. 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

  9. SQL Tuning and Access Advisors How can I make it run faster? DBA Poorly performingSQL statement RestructuredSQL statement SQL TuningAdvisor

  10. Memory Advisors • Shared pool • Database buffer cache • Program Global Area (PGA)

  11. Segment Advisor • Entire tablespace • Individual schema objects

  12. MMON 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 In-memorystatistics 60 minutes Snapshots SGA AWR

  13. 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)

  14. Snapshots Automatic Database Diagnostic Monitor (ADDM) • Runs after each AWR snapshot • Monitors the instance and detects bottlenecks • Results stored within the AWR EM ADDM ADDM results AWR

  15. ADDM Findings

  16. ADDM Recommendations

  17. Summary • In this lesson you should have learned how to: • 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

  18. Practice 15: Proactive Maintenance • This practice covers configuring your database for proactive maintenance.

More Related