les04-準則-警告-基準-wenkub
2023-05-21 18:23:26 本頁面
【正文】 le basis 412 Copyright 169。 2021, Oracle. All rights reserved. Benefits of Metrics DBA Analyze differences. Query a metric. Without metrics With metrics 48 Copyright 169。 2021, Oracle. All rights reserved. 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 parison 44 Copyright 169。Copyright 169。 2021, Oracle. All rights reserved. Limitation of Base Statistics 30 minutes 30 minutes V$SYSSTAT Physical reads I/O I/O Time Time Low rate High rate Statistics just keep growing. 2M 2M 45 Copyright 169。 2021, Oracle. All rights reserved. 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) 49 Copyright 169。 2021, Oracle. All rights reserved. ServerGenerated Alerts Server alerts queue. Metric exceeds threshold. AWR Enterprise Manager Oracle instance 413 Copyright 169。 2021, Oracle. All rights reserved. Metric and Alert Views Recent metrics Metric history V$SYSMETRIC_HISTORY V$SYSMETRIC V$SERVICEME
環(huán)評公示相關(guān)推薦
鄂ICP備17016276號-1