《les04-准则-警告-基准.ppt》由会员分享，可在线阅读，更多相关《les04-准则-警告-基准.ppt（36页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、4Copyright 2006,Oracle.All rights reserved.Metrics,Alerts,and Baselines4-2Copyright 2006,Oracle.All rights reserved.ObjectivesAfter completing this lesson,you should be able to do the following:View metrics by using the metrics history viewsCreate metric thresholdsView alertsCreate metric baselinesE
2、nable adaptive thresholds4-3Copyright 2006,Oracle.All rights reserved.Metrics,Alerts,and BaselinesMetric:Rate of change in a cumulative statisticAlert:Event generated when a monitored metric crosses a thresholdBaseline:Data gathered from a“normal running database”for performance comparison4-4Copyrig
3、ht 2006,Oracle.All rights reserved.Limitation of Base Statistics30 minutes30 minutesV$SYSSTATPhysical readsI/OI/OTimeTimeLow rateHigh rateStatistics just keep growing.2M2M4-5Copyright 2006,Oracle.All rights reserved.Typical Delta ToolsComparison of statistics at two points in time is needed.The foll
4、owing tools produce deltas:StatspackAWR reportsCustomized scripts4-6Copyright 2006,Oracle.All rights reserved.Oracle Database 10g Solution:MetricsBase statistic 1Redo generationMetric 1Metric 2Redo generation/TxClient 1Client 2Client 3Client 4V$METRICNAMEV$SYSMETRICV$SESSMETRICV$FILEMETRICV$EVENTMET
5、RICMMONUser commitUser rollbackV$WAITCLASSMETRICV$SERVICEMETRIC4-7Copyright 2006,Oracle.All rights reserved.Benefits of MetricsDBAAnalyze differences.Query a metric.Without metricsWith metrics4-8Copyright 2006,Oracle.All rights reserved.Viewing Metric History InformationIn memory:V$SYSMETRIC_HISTORY
6、V$FILEMETRIC_HISTORYV$WAITCLASSMETRIC_HISTORYV$SERVICEMETRIC_HISTORYV$SESSION_WAIT_HISTORY(last 10 events)On disk:DBA_HIST_SYSMETRIC_SUMMARYDBA_HIST_SYSMETRIC_HISTORY(alerts only)DBA_HIST_SESSMETRIC_HISTORYDBA_HIST_SYSTEM_EVENT(cumulative)DBA_HIST_FILEMETRIC_HISTORY(alerts only)DBA_HIST_FILESTATXS(c
7、umulative)DBA_HIST_WAITCLASSMET_HISTORY(alert)4-9Copyright 2006,Oracle.All rights reserved.Viewing Detailed Information for a Metric4-10Copyright 2006,Oracle.All rights reserved.Statistic Histograms30 minutesV$SYSSTATPhysical readsI/OTimeHigh rate1248163264 128 256 512222NumberofwaitsTimeperiodV$FIL
8、E_HISTOGRAMIs it areal problem?55004-11Copyright 2006,Oracle.All rights reserved.Histogram ViewsV$EVENT_HISTOGRAM:For each event such as“db file sequential read”V$FILE_HISTOGRAM:For single block reads on a per data file basisV$TEMP_HISTOGRAM:For single block reads on a per temp-file basis4-12Copyrig
9、ht 2006,Oracle.All rights reserved.Server-Generated AlertsServeralertsqueue.Metric exceedsthreshold.AWREnterprise ManagerOracle instance4-13Copyright 2006,Oracle.All rights reserved.Database Control Usage ModelSet up notification rules(paging,e-mail).Correct the problem.Review alert details and advi
10、ce.Enable alerts by setting thresholds.Receive notification.Verify that the problem is resolved.4-14Copyright 2006,Oracle.All rights reserved.Setting Thresholds4-15Copyright 2006,Oracle.All rights reserved.Creating and Testing an Alert1.Specify a threshold.2.Create a test case.3.Check for an alert.2
11、134-16Copyright 2006,Oracle.All rights reserved.Metric and Alert ViewsRecent metricsMetric historyV$SYSMETRIC_HISTORYV$SYSMETRICV$SERVICEMETRICV$METRICNAME.DBA_HIST_SYSMETRIC_HISTORY.DBA_OUTSTANDING_ALERTSDBA_ALERT_HISTORYDBA_THRESHOLDSV$ALERT_TYPES.Server alerts4-17Copyright 2006,Oracle.All rights
12、reserved.User-Defined SQL Metrics4-18Copyright 2006,Oracle.All rights reserved.Practice Overview:Work with MetricsThis practice covers the following topics:View metrics using the metrics history viewsCreate metric thresholdsView alertsClear alerts4-19Copyright 2006,Oracle.All rights reserved.Working
13、 with Metric BaselinesEnable metric baselines.Create a metric baseline.Static baselineMoving window baselineView the baseline statistics.Set a threshold on a baseline.Fixed threshold(percent of maximum)Adaptive threshold4-20Copyright 2006,Oracle.All rights reserved.Enabling Metric Baselining4-21Copy
14、right 2006,Oracle.All rights reserved.Creating Static Metric Baselines4-22Copyright 2006,Oracle.All rights reserved.Creating Static Metric Baselines4-23Copyright 2006,Oracle.All rights reserved.Time GroupingBaseline periodTimegroupedDayand nightHourof dayWeekdaysand weekendDayof weekAllhoursAlldays8
15、am11am7am7am7pm7am7am7pmMoSuMoSuMoSa&SuDailyWeekly4-24Copyright 2006,Oracle.All rights reserved.Time Grouping:ConsiderationsMo Tu We Th Fr Sa SuNoSufficient data?Day of weekGrouped by7 daysMoving window sizeYesSufficient data?Day of weekGrouped by14 daysMoving window sizeYesSufficient data?Weekdays
16、and weekendGrouped by7 daysMoving window sizeDatapointsWeekdays WeekendMo Tu We Th Fr Sa SuDatapointsDatapointsSufficiency level1 week ago2 weeks ago4-25Copyright 2006,Oracle.All rights reserved.Activating the StaticMetric Baseline4-26Copyright 2006,Oracle.All rights reserved.Activating the Moving W
17、indowMetric Baseline4-27Copyright 2006,Oracle.All rights reserved.Visualizing Metric Baseline Statistics4-28Copyright 2006,Oracle.All rights reserved.Setting Adaptive Alert Thresholds4-29Copyright 2006,Oracle.All rights reserved.Setting Adaptive Alert Thresholds4-30Copyright 2006,Oracle.All rights r
18、eserved.Metric Baseline and Adaptive Threshold:ConsiderationsBaselining 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.4-31Copyri
19、ght 2006,Oracle.All rights reserved.Classification of Eligible MetricsDatabase Time(centiseconds per second)Response Time(per transaction)System Response Time(centiseconds)Performance MetricsExecutes(per second)Redo Generated(per second)Network Bytes(per second)Physical Writes(per second)Physical Re
20、ads(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 Metrics4-32Copyright 2006,Oracle
21、.All rights reserved.Metric Baseline:Normalized View4-33Copyright 2006,Oracle.All rights reserved.Configuring Normalization Metrics4-34Copyright 2006,Oracle.All rights reserved.Adaptive Thresholds and the All Metrics Page4-35Copyright 2006,Oracle.All rights reserved.Practice Overview:Work with Basel
22、inesThis practice covers the following topics:Create a static metric baseline View the baseline data Enable adaptive thresholdsView deviations from the baseline 4-36Copyright 2006,Oracle.All rights reserved.SummaryIn this lesson,you should have learned how to:View metrics by using the metrics history viewsCreate metric thresholdsView alertsCreate metric baselinesEnable adaptive thresholds