metric和Alerts

now:   v$sysmetric

1 hour: v$sysmetric_history

7 Days: DBA_HIST_SYSMETRIC_summary

15 Ses: v$sessmetric

DBA_HIST_SYSMETRIC_HISTORY

与Alerts 相关的数据字典如下表：

 

View

Description

DBA_THRESHOLDS

Lists the threshold settings defined for the instance

DBA_OUTSTANDING_ALERTS

Describes the outstanding alerts in the database

DBA_ALERT_HISTORY

Lists a history of alerts that have been cleared

V$ALERT_TYPES

Provides information such as group and type for each alert

V$METRICNAME

Contains the names, identifiers, and other information about the system metrics

V$METRIC

Contains system-level metric values

V$METRIC_HISTORY

Contains a history of system-level metric values

 

Metrics每分钟更新记录有这些视图有：

V$SYSMETRIC,

V$SESSMETRIC,

V$SERVICEMETRIC,

V$METRICNAME

V$FILEMETRIC,

V$EVENTMETRIC,

V$WAITCLASSMETRIC

V$SYSMETRIC_HISTORY,DBA_HIST_*