[bbk5188]第68集 第7章 - 数据库的维护 05
服务器预警信息.
- 给dump区设置阀值，提前预警.
- 快照太旧,提前预警.
- instance挂起,提前预警.
Automated Maintenance Tasks
Autotask maintenance process
- Maintenance Window opens.
- Autotask background process schedules jobs.
- Scheduler initiates jobs.
- Resource Manager limits impact of Autotask jobs.
Default Autotask maintenance jobs
- Gathering optimizer statistics
- Automatic Segment Advisor
- Automatic SQL Advisor
Automated Maintenance Tasks
Automated Maintenance Tasks Configuration
Server-Generated Alerts
Setting Thresholds
Creating and Testing an Alert
Alerts Notification
Reacting to Alerts
- If neccessary,you should gather more input(for example,by running ADDM or another advisor)
- Investigate critical errors.
- Take corrective measures.
- Acknowledge alerts thatare not automatically cleared.
Alter Types and Clearing Alerts
Summary
In this lesson,you should have learned how to:
- Manage optimizer statistics
- Manage the Automatic Workload Repository(AWR)
- Use the AUtomatic Database Diagnostic Monitor(ADDM)
- Describe and use the advisory framework
- Set alert thresholds
- Use Server-Generated alerts
- Use automated tasks
- oracle提供的很多build-in的scheduler，实时监控、执行数据库运行情况，统计指标.
