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

les04-准则-警告-基准36
Viewing Metric History Information
In memory:
V$SYSMETRIC_HISTORY
V$FILEMETRIC_HISTORY
V$WAITCLASSMhold 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)Network Bytes (per second)Physical Writes (per second)Physical Reads (per second)Current Logons CountUser Calls (per second)Number of Transactions (per second)
Workload Volume Metrics
Database Block Changes (per transaction)
Enqueue Requests (per transaction)
Total Parses (per transaction)
Session Logical Reads (per transaction)
Workload Type Metrics
Metric Baseli