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

该【les04-准则-警告-基准36课件 】是由【yzhlyb】上传分享，文档一共【36】页，该文档可以免费在线阅读，需要了解更多关于【les04-准则-警告-基准36课件 】的内容，可以使用淘豆网的站内搜索功能，选择自己适合的文档，以下文字是截取该文章内的部分文字，如需要获得完整电子版，请下载此文档到您的设备，方便您编辑和打印。Metrics,Alerts,andBaselines
Objectives
Aftercompletingthislesson,youshouldbeabletodothefollowing:
Viewmetricsbyusingthemetricshistoryviews
Createmetricthresholds
Viewalerts
Createmetricbaselines
Enableadaptivethresholds
Metrics,Alerts,andBaselines
Metric:Rateofchangeinacumulativestatistic
Alert:Eventgeneratedwhenamonitoredmetriccrossesathreshold
Baseline:Datagatheredfroma“normalrunningdatabase”forperformancecomparison
LimitationofBaseStatistics
30minutes
30minutes
V$SYSSTATPhysicalreads
I/O
I/O
Time
Time
Lowrate
Highrate
Statisticsjustkeepgrowing.
2M
2M
TypicalDeltaTools
Comparisonofstatisticsattwopointsintimeisneeded.
Thefollowingtoolsproducedeltas:
Statspack
AWRreports
Customizedscripts
BenefitsofMetrics
DBA
Analyzedifferences.
Queryametric.
Withoutmetrics
Withmetrics
ViewingMetricHistoryInformation
Inmemory:
V$SYSMETRIC_HISTORY
V$FILEMETRIC_HISTORY
V$WAITCLASSMETRIC_HISTORY
V$SERVICEMETRIC_HISTORY
V$SESSION_WAIT_HISTORY(last10events)
Ondisk:
DBA_HIST_SYSMETRIC_SUMMARY
DBA_HIST_SYSMETRIC_HISTORY(alertsonly)
DBA_HIST_SESSMETRIC_HISTORY
DBA_HIST_SYSTEM_EVENT(cumulative)
DBA_HIST_FILEMETRIC_HISTORY(alertsonly)
DBA_HIST_FILESTATXS(cumulative)
DBA_HIST_WAITCLASSMET_HISTORY(alert)
StatisticHistograms
30minutes
V$SYSSTATPhysicalreads
I/O
Time
Highrate
1
2
4
8
16
32
64
128
256
512
…
222
Numberofwaits
Timeperiod
V$FILE_HISTOGRAM
Isitarealproblem?
5500
HistogramViews
V$EVENT_HISTOGRAM:Foreacheventsuchas“dbfilesequentialread”
V$FILE_HISTOGRAM:Forsingleblockreadsonaperdatafilebasis
V$TEMP_HISTOGRAM:Forsingleblockreadsonapertemp-filebasis
Server-GeneratedAlerts
Serveralertsqueue.
Metricexceeds
threshold.
AWR
EnterpriseManager
Oracle
instance