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_*