pletingthislesson,youshouldbeabletodothefollowing:ViewmetricsbyusingthemetricshistoryviewsCreatemetricthresholdsViewalertsCreatemetricbaselinesEnableadaptivethresholdsMetrics,Alerts,andBaselinesMetric:RateofchangeinacumulativestatisticAlert:rossesathresholdBaseline:Datagatheredfroma“normalrunningdatabase”parisonLimitationofBaseStatistics30minutes30minutesV$SYSSTATPhysicalreadsI/OI/:StatspackAWRreportsCustomizedscriptsOracleDatabase10gSolution:MetricsBasestatistic1RedogenerationMetric1Metric2Redogeneration/TxClient1Client2Client3Client4V$AMEV$SYSMETRICV$SESSMETRICV$FILEMETRICV$mitUserrollbackV$WAITCLASSMETRICV$: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)ViewingDetailedInformationforaMetricStatisticHistograms30minutesV$SYSSTATPhysicalreadsI/OTimeHighrate1248163264128256512…222NumberofwaitsTimeperiodV$FILE_HISTOGRAMIsitarealproblem?5500HistogramViewsV$EVENT_HISTOGRAM:Foreacheventsuchas“dbfilesequentialread”V$FILE_HISTOGRAM:ForsingleblockreadsonaperdatafilebasisV$TEMP_HISTOGRAM:Forsingleblockreadsonapertemp-filebasis
les准则警告基准 来自淘豆网www.taodocs.com转载请标明出处.