文档介绍：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
Time grouped
Day and night
Hour of day
Weekdays and weekend
Day of week
All hours
All days
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
Data points
Weekdays Weekend
Mo Tu We Th Fr Sa Su
Data points
Data points
Sufficiency level
1 week ago
2 weeks ago
Activating the Static Metric Baseline
Activating the Moving Window Metric 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 Count User 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