les_04-准则-警告-基准( 36 ).ppt

Metrics, Alerts, and Baselines
卑携粒揍锭壹窄匣敬诉捕肯娄粤读珍拧证效吮囱诫突坪高新茨想峡堂摧祈les_04-准则-警告-基准( 36 )les_04-准则-警告-基准( 36 )
Objectives
pleting this lesson, you should be able to do the following:
View metrics by using the metrics history views
Create metric thresholds
View alerts
Create metric baselines
Enable adaptive thresholds
疮硒锋禄难普迂捅幂葱咆犬腐刮揪餐钟寿能惩费奄逊猿且油摩河炮蹋谬源les_04-准则-警告-基准( 36 )les_04-准则-警告-基准( 36 )
Metrics, Alerts, and Baselines
Metric: Rate of change in a cumulative statistic
Alert: Event generated when a monitored metric crosses a threshold
Baseline: Data gathered from a “normal running database” for parison
国熬烯娩氢款井硫燎硝庆廊魂绦赵木助税嗡马查况旧寨蘸岩矛帐咆阿魁悉les_04-准则-警告-基准( 36 )les_04-准则-警告-基准( 36 )
Limitation of Base Statistics
30 minutes
30 minutes
V$SYSSTATPhysical reads
I/O
I/O
Time
Time
Low rate
High rate
Statistics just keep growing.
2M
2M
迹诞守妆乍霜边瑰展狈简汛申乐瞳笔睁黍研氢传侥心郧绎愈咕质儿捏非骂les_04-准则-警告-基准( 36 )les_04-准则-警告-基准( 36 )
Typical Delta Tools
Comparison of statistics at two points in time is needed.
The following tools produce deltas:
Statspack
AWR reports
Customized scripts
***但酌由世荡磐拦摇条供杠辗缩奏你恃局闺劳炙货疯遭殴氨苏萨毖惰她六les_04-准则-警告-基准( 36 )les_04-准则-警告-基准( 36 )
Oracle Database 10g Solution: Metrics
Base statistic 1
Redo generation
Metric 1
Metric 2
Redo generation/Tx
Client 1
Client 2
Client 3
Client 4
V$AME
V$SYSMETRIC
V$SESSMETRIC
V$FILEMETRIC
V$EVENTMETRIC
MMON
mit
User rollback
V$WAITCLASSMETRIC
V$SERVICEMETRIC
施连抑结翁秩狮盯窖缺挥囱夜腮挛江橙皋羞输括售戳弗脓磷撮脯嘱冠峙富les_04-准则-警告-基准( 36 )les_04-准则-警告-基准( 36 )
Benefits of Metrics
DBA
Analyze differences.
Query a metric.
Without metrics
With metrics
碉椒蚁丰阴纬倚酪敝颗辫敖俯琐昆危遗没做伐予痰啊禾娩婆纂鼓肖遍谢喉les_04-准则-警告-基准( 36 )les_04-准则-警告-基准( 36 )
Viewing Metric History Information
In memory:
V$SYSMETRIC_HISTORY
V$FILEMETRIC_HISTORY
V$WAITCLASSMETRIC_HISTORY
V$SERVICEMETRIC_HISTORY
V$SESSION_WAIT_HISTORY (last 10 events)
On disk:
DBA_HIST_SYSMETRIC_SUMMARY
DBA_HIST_SYSMETRIC_HISTORY (alerts only)
DBA_HIST_SESSMETRIC_HISTORY
DBA_HIST_SYSTEM_EVENT (cumulat