les04-准则-警告-基准36.ppt

les04-准则-警告-基准36
Objectives
After completing this lesson, you should be able to do the following:
View metrics by uss
User-Defined SQL Metrics
Practice Overview: Work with Metrics
This practice covers the following topics:
View metrics using the metrics history views
Create metric thresholds
View alerts
Clear alerts
Working with Metric Baselines
Enable metric baselines.
Create a metric baseline.
Static baseline
Moving window baseline
View the baseline statistics.
Set a threshold on a baseline.
Fixed threshold (percent of maximum)
Adaptive threshold
Enabling Metric Baselining
Creating Static Metric Baselines
Creating Static Metric Baselines
Time Grouping
Baseline period
Timegrouped
Dayand night
Hourof day
Weekdaysand weekend
Dayof week
Allhours
Alldays
8am
11am
7am
7am
7pm
7am
7am
7pm
Mo
Su
Mo
Su
Mo
Sa&Su
Daily
Weekly
Time Grouping: Considerations
Mo Tu We Th Fr Sa Su
No
Sufficient data?
Day of week
Grouped by
7 days
Moving window size
Yes
Sufficient data?
Day of week
Grouped by
14 days
Moving window size
Yes
Sufficient data?
Weekdays and weekend
Grouped by
7 days
Moving window size
Datapoints
Weekdays Weekend
Mo Tu We Th Fr Sa Su
Datapoints
Datapoints
Sufficiency level
1 week ago
2 weeks ago
Activating the StaticMetric Baseline
Activating the Moving WindowMetric Baseline
Visualizing Metric Baseline Statistics
Setting Adaptive Alert Thresholds
Setting Adaptive Alert Thresholds
Metric Baseline and Adaptive Threshold: Considerations
Baselining must be enabled using Enterprise Manager.
Only one moving window baseline can be defined.
Multiple static baselines can be defined.
Only one baseline can be active at a time.
Adaptive thresholds require an active baseline.
Classification of Eligible Metrics
Database Time (centiseconds per second)Response Time (per transaction)System Response Time (centiseconds)
Performance Metrics
Executes (per second)Redo Generated (per second)Networ