les04-准则-警告-基准36.pptVIP

Metrics, Alerts, and Baselines Objectives After completing this lesson, you should be able to do the following: View metrics by using the metrics history views Create metric thresholds View alerts Create metric baselines Enable adaptive thresholds Metrics, Alerts, and Baselines Metric: Rate of change in a cumulative statistic Alert: Event generated when a monitored metric crosses a threshold Baseline: Data gathered from a “normal running database” for performance comparison Limitation of Base Statistics Typical Delta Tools Comparison of statistics at two points in time is needed. The following tools produce deltas: Statspack AWR reports Customized scripts Oracle Database 10g Solution: Metrics Benefits of Metrics Viewing Metric History Information In memory: V$SYSMETRIC_HISTORY V$FILEMETRIC_HISTORY V$WAITCLASSMETRIC_HISTORY V$SERVICEMETRIC_HISTORY V$SESSION_WAIT_HISTORY (last 10 events) On disk: DBA_HIST_SYSMETRIC_SUMMARY DBA_HIST_SYSMETRIC_HISTORY (alerts only) DBA_HIST_SESSMETRIC_HISTORY DBA_HIST_SYSTEM_EVENT (cumulative) DBA_HIST_FILEMETRIC_HISTORY (alerts only) DBA_HIST_FILESTATXS (cumulative) DBA_HIST_WAITCLASSMET_HISTORY (alert) Viewing Detailed Information for a Metric Statistic Histograms Histogram Views V$EVENT_HISTOGRAM: For each event such as “db file sequential read” V$FILE_HISTOGRAM: For single block reads on a per data file basis V$TEMP_HISTOGRAM: For single block reads on a per temp-file basis Server-Generated Alerts Database Control Usage Model Setting Thresholds Creating and Testing an Alert Specify a threshold. Create a test case. Check for an alert. Metric and Alert Views User-Defined SQL Metrics Practice Overview: Work with Metrics This practice covers the following topics: View metrics using the metrics history views Create metric thresholds View alerts Clear alerts Working with Metric Baselines Enable metric baselines. Create a metric baseline. Static baseline Moving window baseline View the baseline statistics. Set a threshold on a baseline. F