DBA_THRESHOLDS

Oracle 11gR1

DBA_THRESHOLDS describes all thresholds.

Column	Datatype	NULL	Description
METRICS_NAME	VARCHAR2(64)		Metrics name
WARNING_OPERATOR	VARCHAR2(12)		Relational operator for warning thresholds: · GT · EQ · LT · LE · GE · CONTAINS · NE · DO NOT CHECK · DO_NOT_CHECK
WARNING_VALUE	VARCHAR2(256)		Warning threshold value
CRITICAL_OPERATOR	VARCHAR2(12)		Relational operator for critical thresholds: · GT · EQ · LT · LE · GE · CONTAINS · NE · DO NOT CHECK · DO_NOT_CHECK
CRITICAL_VALUE	VARCHAR2(256)		Critical threshold value
OBSERVATION_PERIOD	NUMBER		Observation period length (in minutes)
CONSECUTIVE_OCCURRENCES	NUMBER		Number of occurrences before an alert is issued
INSTANCE_NAME	VARCHAR2(16)		Instance name; null for database-wide alerts
OBJECT_TYPE	VARCHAR2(64)		Object type: · SYSTEM · SERVICE · EVENT_CLASS · TABLESPACE · FILE
OBJECT_NAME	VARCHAR2(513)		Name of the object for which the threshold is set
STATUS	VARCHAR2(7)		Indicates whether the threshold is applicable on a valid object (VALID) or not (INVALID)

Note:

1.

select * from dba_thresholds;

METRICS_ NAME	WARNING_ OPERATOR	WARNING_ VALUE	CRITICAL_ OPERATOR	CRITICAL_ VALUE	OBSERVATION_ PERIOD	CONSECUTIVE_ OCCURRENCES	INSTANCE_ NAME	OBJECT_ TYPE	OBJECT_ NAME	STATUS
Tablespace Space Usage	GE	85	GE	97	1	1	database_wide	TABLESPACE	NULL	VALID

2. The following dictionary views provide information about server alerts:

• 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 and V$METRIC_HISTORY views contain system-level metric values in memory.

Oracle data dictionary views