DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.CDB_THRESHOLDS

Object Details
Object Name: CDB_THRESHOLDS
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Desription of all thresholds in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
METRICS_NAME VARCHAR2 (64)
Metrics name
WARNING_OPERATOR VARCHAR2 (12)
Relational operator for warning thresholds
WARNING_VALUE VARCHAR2 (256)
Warning threshold value
CRITICAL_OPERATOR VARCHAR2 (12)
Relational operator for critical thresholds
CRITICAL_VALUE VARCHAR2 (256)
Critical threshold value
OBSERVATION_PERIOD NUMBER

Observation period length (in minutes)
CONSECUTIVE_OCCURRENCES NUMBER

Has to occur so many times before an alert is issued
INSTANCE_NAME VARCHAR2 (16)
Instance name - NULL for database-wide alerts
OBJECT_TYPE VARCHAR2 (64)
Object type: SYSTEM, TABLESPACE, SERVICE, FILE, etc
OBJECT_NAME VARCHAR2 (513)
Name of the object for which the threshold is set
STATUS VARCHAR2 (7)
Whether threshold is applicable on a valid object
CON_ID NUMBER

container id
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT METRICS_NAME
,      WARNING_OPERATOR
,      WARNING_VALUE
,      CRITICAL_OPERATOR
,      CRITICAL_VALUE
,      OBSERVATION_PERIOD
,      CONSECUTIVE_OCCURRENCES
,      INSTANCE_NAME
,      OBJECT_TYPE
,      OBJECT_NAME
,      STATUS
,      CON_ID
FROM SYS.CDB_THRESHOLDS;

Dependencies

[top of page]

SYS.CDB_THRESHOLDS does not reference any database object

SYS.CDB_THRESHOLDS is referenced by following:

SchemaPUBLIC
SynonymCDB_THRESHOLDS