les准则警告基准课件

1、ObjectivesAfter completing this lesson, you should be able to do the following:View metrics by using the metrics history viewsCreate metric thresholdsView alertsCreate metric baselinesEnable adaptive thresholdsObjectivesAfter completing thiMetrics, Alerts, and BaselinesMetric: Rate of change in a cu

2、mulative statisticAlert: Event generated when a monitored metric crosses a thresholdBaseline: Data gathered from a “normal running database” for performance comparisonMetrics, Alerts, and BaselinesLimitation of Base Statistics30 minutes30 minutesV$SYSSTATPhysical readsI/OI/OTimeTimeLow rateHigh rate

3、Statistics just keep growing.2M2MLimitation of Base Statistics3Typical Delta ToolsComparison of statistics at two points in time is needed.The following tools produce deltas:StatspackAWR reportsCustomized scriptsTypical Delta ToolsComparison Oracle Database 10g Solution: MetricsBase statistic 1Redo

4、generationMetric 1Metric 2Redo generation/TxClient 1Client 2Client 3Client 4V$METRICNAMEV$SYSMETRICV$SESSMETRICV$FILEMETRICV$EVENTMETRICMMONUser commitUser rollbackV$WAITCLASSMETRICV$SERVICEMETRICOracle Database 10g Solution: Benefits of MetricsDBAAnalyze differences.Query a metric.Without metricsWi

5、th metricsBenefits of MetricsDBAAnalyze Viewing Metric History InformationIn memory:V$SYSMETRIC_HISTORYV$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_SESSMET

6、RIC_HISTORYDBA_HIST_SYSTEM_EVENT (cumulative)DBA_HIST_FILEMETRIC_HISTORY (alerts only)DBA_HIST_FILESTATXS (cumulative)DBA_HIST_WAITCLASSMET_HISTORY (alert)Viewing Metric History InformaViewing Detailed Information for a MetricViewing Detailed Information fStatistic Histograms30 minutesV$SYSSTATPhysi

7、cal readsI/OTimeHigh rate1248163264128256512222NumberofwaitsTimeperiodV$FILE_HISTOGRAMIs it areal problem?5500Statistic Histograms30 minutesHistogram 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_HISTOG

8、RAM: For single block reads on a per temp-file basisHistogram ViewsV$EVENT_HISTOGRServer-Generated AlertsServeralertsqueue.Metric exceedsthreshold.AWREnterprise ManagerOracle instanceServer-Generated AlertsServerDatabase Control Usage ModelSet up notification rules (paging, e-mail).Correct the probl

9、em.Review alert details and advice.Enable alerts by setting thresholds.Receive notification.Verify that the problem is resolved.Database Control Usage ModelSeSetting ThresholdsSetting ThresholdsCreating and Testing an AlertSpecify a threshold.Create a test case.Check for an alert.213Creating and Tes

10、ting an AlertSMetric and Alert ViewsRecent metricsMetric historyV$SYSMETRIC_HISTORYV$SYSMETRICV$SERVICEMETRICV$METRICNAME.DBA_HIST_SYSMETRIC_HISTORY.DBA_OUTSTANDING_ALERTSDBA_ALERT_HISTORYDBA_THRESHOLDSV$ALERT_TYPES.Server alertsMetric and Alert ViewsRecent mUser-Defined SQL MetricsUser-Defined SQL

11、MetricsPractice Overview: Work with MetricsThis practice covers the following topics:View metrics using the metrics history viewsCreate metric thresholdsView alertsClear alertsPractice Overview: Work with Working with Metric BaselinesEnable metric baselines.Create a metric baseline.Static baselineMo

12、ving window baselineView the baseline statistics.Set a threshold on a baseline.Fixed threshold (percent of maximum) Adaptive thresholdWorking with Metric BaselinesEEnabling Metric BaseliningEnabling Metric BaseliningCreating Static Metric BaselinesCreating Static Metric BaselinCreating Static Metric

13、 BaselinesCreating Static Metric BaselinTime GroupingBaseline periodTimegroupedDayand nightHourof dayWeekdaysand weekendDayof weekAllhoursAlldays8am11am7am7am7pm7am7am7pmMoSuMoSuMoSa&SuDailyWeeklyTime GroupingBaseline periodTiTime Grouping: ConsiderationsMo Tu We Th Fr Sa SuNoSufficient data?Day of

14、weekGrouped by7 daysMoving window sizeYesSufficient data?Day of weekGrouped by14 daysMoving window sizeYesSufficient data?Weekdays and weekendGrouped by7 daysMoving window sizeDatapointsWeekdays WeekendMo Tu We Th Fr Sa SuDatapointsDatapointsSufficiency level1 week ago2 weeks agoTime Grouping: Consi

15、derationsMActivating the StaticMetric BaselineActivating the StaticMetric BActivating the Moving WindowMetric BaselineActivating the Moving WindowMVisualizing Metric Baseline StatisticsVisualizing Metric Baseline StSetting Adaptive Alert ThresholdsSetting Adaptive Alert ThreshoSetting Adaptive Alert

16、 ThresholdsSetting Adaptive Alert ThreshoMetric 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 req

17、uire an active baseline.Metric Baseline and Adaptive 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

18、 (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 MetricsClassification of Eligible MetMetric Baseline: Normalized Vie