Metrics,Alerts,andBaselinesles04-準(zhǔn)則-警告-基準(zhǔn)共36頁，您現(xiàn)在瀏覽的是第1頁!ObjectivesAfterpletingthislesson,youshouldbeabletodothefollowing:ViewmetricsbyusingthemetricshistoryviewsCreatemetricthresholdsViewalertsCreatemetricbaselinesEnableadaptivethresholdsles04-準(zhǔn)則-警告-基準(zhǔn)共36頁，您現(xiàn)在瀏覽的是第2頁!Metrics,Alerts,andBaselinesMetric:RateofchangeinacumulativestatisticAlert:EventgeneratedwhenamonitoredmetriccrossesathresholdBaseline:Datagatheredfroma“normalrunningdatabase”forperformanceparisonles04-準(zhǔn)則-警告-基準(zhǔn)共36頁，您現(xiàn)在瀏覽的是第3頁!TypicalDeltaToolsComparisonofstatisticsattwopointsintimeisneeded.Thefollowingtoolsproducedeltas:StatspackAWRreportsCustomizedscriptsles04-準(zhǔn)則-警告-基準(zhǔn)共36頁，您現(xiàn)在瀏覽的是第4頁!BenefitsofMetricsDBAAnalyzedifferences.Queryametric.WithoutmetricsWithmetricsles04-準(zhǔn)則-警告-基準(zhǔn)共36頁，您現(xiàn)在瀏覽的是第5頁!ViewingDetailedInformationforaMetricles04-準(zhǔn)則-警告-基準(zhǔn)共36頁，您現(xiàn)在瀏覽的是第6頁!HistogramViewsV$EVENT_HISTOGRAM:Foreacheventsuchas“dbfilesequentialread”V$FILE_HISTOGRAM:ForsingleblockreadsonaperdatafilebasisV$TEMP_HISTOGRAM:Forsingleblockreadsonapertemp-filebasisles04-準(zhǔn)則-警告-基準(zhǔn)共36頁，您現(xiàn)在瀏覽的是第7頁!DatabaseControlUsageModelSetupnotificationrules(paging,e-mail).Correcttheproblem.Reviewalertdetailsandadvice.Enablealertsbysettingthresholds.Receivenotification.Verifythattheproblemisresolved.les04-準(zhǔn)則-警告-基準(zhǔn)共36頁，您現(xiàn)在瀏覽的是第8頁!CreatingandTestinganAlertSpecifyathreshold.Createatestcase.Checkforanalert.213les04-準(zhǔn)則-警告-基準(zhǔn)共36頁，您現(xiàn)在瀏覽的是第9頁!User-DefinedSQLMetricsles04-準(zhǔn)則-警告-基準(zhǔn)共36頁，您現(xiàn)在瀏覽的是第10頁!WorkingwithMetricBaselinesEnablemetricbaselines.Createametricbaseline.StaticbaselineMovingwindowbaselineViewthebaselinestatistics.Setathresholdonabaseline.Fixedthreshold(percentofmaximum)Adaptivethresholdles04-準(zhǔn)則-警告-基準(zhǔn)共36頁，您現(xiàn)在瀏覽的是第11頁!CreatingStaticMetricBaselinesles04-準(zhǔn)則-警告-基準(zhǔn)共36頁，您現(xiàn)在瀏覽的是第12頁!TimeGroupingBaselineperiodTime

groupedDay

andnightHour

ofdayWeekdays

andweekendDay

ofweekAll

hoursAll

days8am11am7am7am7pm7am7am7pmMoSuMoSuMoSa&SuDailyWeeklyles04-準(zhǔn)則-警告-基準(zhǔn)共36頁，您現(xiàn)在瀏覽的是第13頁!ActivatingtheStatic

MetricBaselineles04-準(zhǔn)則-警告-基準(zhǔn)共36頁，您現(xiàn)在瀏覽的是第14頁!VisualizingMetricBaselineStatisticsles04-準(zhǔn)則-警告-基準(zhǔn)共36頁，您現(xiàn)在瀏覽的是第15頁!SettingAdaptiveAlertThresholdsles04-準(zhǔn)則-警告-基準(zhǔn)共36頁，您現(xiàn)在瀏覽的是第16頁!ClassificationofEligibleMetricsDatabaseTime(centisecondspersecond)

ResponseTime(pertransaction)

SystemResponseTime(centiseconds)PerformanceMetricsExecutes(persecond)

RedoGenerated(persecond)

NetworkBytes(persecond)

PhysicalWrites(persecond)

PhysicalReads(persecond)

CurrentLogonsCount

UserCalls(persecond)

NumberofTransactions(persecond)WorkloadVolumeMetricsDatabaseBlockChanges(pertransaction)EnqueueRequests(pertransaction)TotalParses(pertransaction)SessionLogicalReads(pertransaction)WorkloadTypeMetricsles04-準(zhǔn)則-警告-基準(zhǔn)共36頁，您現(xiàn)在瀏覽的是第17頁!ConfiguringNormalizationMetricsles04-準(zhǔn)則-警告-基準(zhǔn)共36頁，您現(xiàn)在瀏覽的是第18頁!PracticeOverview:

WorkwithBaselinesThispracticecoversthefollowingtopics:CreateastaticmetricbaselineViewthebaselinedataEnableadaptivethresholdsViewdeviationsfromthebaselineles04-準(zhǔn)則-警告-基準(zhǔn)共36頁，您現(xiàn)在瀏覽的是第19頁!LimitationofBaseStatistics30minutes30minutesV$SYSSTAT

PhysicalreadsI/OI/OTimeTimeLowrateHighrateStatisticsjustkeepgrowing.2M2Mles04-準(zhǔn)則-警告-基準(zhǔn)共36頁，您現(xiàn)在瀏覽的是第20頁!OracleDatabase10gSolution:MetricsBasestatistic1RedogenerationMetric1Metric2Redogeneration/TxClient1Client2Client3Client4V$METRICNAMEV$SYSMETRICV$SESSMETRICV$FILEMETRICV$EVENTMETRICMMONUsermitUserrollbackV$WAITCLASSMETRICV$SERVICEMETRICles04-準(zhǔn)則-警告-基準(zhǔn)共36頁，您現(xiàn)在瀏覽的是第21頁!ViewingMetricHistoryInformationInmemory:V$SYSMETRIC_HISTORYV$FILEMETRIC_HISTORYV$WAITCLASSMETRIC_HISTORYV$SERVICEMETRIC_HISTORYV$SESSION_WAIT_HISTORY(last10events)Ondisk:DBA_HIST_SYSMETRIC_SUMMARYDBA_HIST_SYSMETRIC_HISTORY(alertsonly)DBA_HIST_SESSMETRIC_HISTORYDBA_HIST_SYSTEM_EVENT(cumulative)DBA_HIST_FILEMETRIC_HISTORY(alertsonly)DBA_HIST_FILESTATXS(cumulative)DBA_HIST_WAITCLASSMET_HISTORY(alert)les04-準(zhǔn)則-警告-基準(zhǔn)共36頁，您現(xiàn)在瀏覽的是第22頁!StatisticHistograms30minutesV$SYSSTAT

PhysicalreadsI/OTimeHighrate1248163264128256512…222Number

of

waitsTime

periodV$FILE_HISTOGRAMIsita

realproblem?5500les04-準(zhǔn)則-警告-基準(zhǔn)共36頁，您現(xiàn)在瀏覽的是第23頁!Server-GeneratedAlertsServer

alerts

queue.Metricexceedsthreshold.AWREnterpriseManagerOracleinstanceles04-準(zhǔn)則-警告-基準(zhǔn)共36頁，您現(xiàn)在瀏覽的是第24頁!SettingThresholdsles04-準(zhǔn)則-警告-基準(zhǔn)共36頁，您現(xiàn)在瀏覽的是第25頁!MetricandAlertViewsRecentmetricsMetrichistoryV$SYSMETRIC_HISTORYV$SYSMETRICV$SERVICEMETRICV$METRICNAME...DBA_HIST_SYSMETRIC_HISTORY...DBA_OUTSTANDING_ALERTSDBA_ALERT_HISTORYDBA_THRESHOLDSV$ALERT_TYPES...Serveralertsles04-準(zhǔn)則-警告-基準(zhǔn)共36頁，您現(xiàn)在瀏覽的是第26頁!PracticeOverview:

WorkwithMetricsThispracticecoversthefollowingtopics:ViewmetricsusingthemetricshistoryviewsCreatemetricthresholdsViewalertsClearalertsles04-準(zhǔn)則-警告-基準(zhǔn)共36頁，您現(xiàn)在瀏覽的是第27頁!EnablingMetricBaseliningles04-準(zhǔn)則-警告-基準(zhǔn)共36頁，您現(xiàn)在瀏覽的是第28頁!CreatingStaticMetricBaselinesles04-準(zhǔn)則-警告-基準(zhǔn)共36頁，您現(xiàn)在瀏覽的是第29頁!TimeGrouping:ConsiderationsMoTuWeThFrSaSuNoSufficientdata?DayofweekGroupedby7daysMovingwindowsizeYesSufficientdata?DayofweekGroupedby14daysMovingwindowsizeYesSufficientdata?WeekdaysandweekendGroupedby7daysMovingwindowsizeData

pointsWeekdaysWeekendMoTuWeThFrSaSuData

pointsData

pointsSufficiencylevel1weekago2weeksagoles04-準(zhǔn)則-警告-基準(zhǔn)共36頁，您現(xiàn)在瀏覽的是第30頁!ActivatingtheMovingWindow

MetricBaselineles04-準(zhǔn)則-警告-基準(zhǔn)共36頁，您現(xiàn)在瀏覽的是第31頁!SettingAdaptiveAlertThresholdsles04-準(zhǔn)則-警告-基準(zhǔn)共36頁，您現(xiàn)在瀏覽的是第32頁!MetricBaselineandAdaptive

Thresho