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

VIEW: SYS.CDB_ALERT_HISTORY_DETAIL

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

Detailed alert history in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
SEQUENCE_ID NUMBER
Yes Alert sequence number
REASON_ID NUMBER

Alert reason id
OWNER VARCHAR2 (128)
Owner of the object on which alert is issued
OBJECT_NAME VARCHAR2 (513)
Name of the object
SUBOBJECT_NAME VARCHAR2 (128)
Name of the subobject (partition)
OBJECT_TYPE VARCHAR2 (64)
Type of the object (table, tablespace, etc)
REASON VARCHAR2 (4000)
Reason for the alert
TIME_SUGGESTED TIMESTAMP(6) WITH TIME ZONE (13)
Time when the alert was last updated
CREATION_TIME TIMESTAMP(6) WITH TIME ZONE (13)
Time when the alert was first produced
SUGGESTED_ACTION VARCHAR2 (4000)
Advice of recommended action
ADVISOR_NAME VARCHAR2 (128)
Name of advisor to be invoked for more information
METRIC_VALUE NUMBER

Value of the related metrics
MESSAGE_TYPE VARCHAR2 (12)
Message type - warning or notification
MESSAGE_GROUP VARCHAR2 (64)
Name of the group that the alert belongs to
MESSAGE_LEVEL NUMBER

Severity level (1-32)
HOSTING_CLIENT_ID VARCHAR2 (64)
ID of the client or security group etc. that the alert relates to
MODULE_ID VARCHAR2 (64)
ID of the module that originated the alert
PROCESS_ID VARCHAR2 (128)
Process id
HOST_ID VARCHAR2 (256)
DNS hostname of originating host
HOST_NW_ADDR VARCHAR2 (256)
IP or other network address of originating host
INSTANCE_NAME VARCHAR2 (16)
Originating instance name
INSTANCE_NUMBER NUMBER

Originating instance number
USER_ID VARCHAR2 (128)
User id
EXECUTION_CONTEXT_ID VARCHAR2 (128)
ID of the thread of execution
ERROR_INSTANCE_ID VARCHAR2 (142)
ID of an error instance plus a sequence number
RESOLUTION VARCHAR2 (11)
Cleared or Outstanding
STATE_TRANSITION_NUMBER NUMBER
Yes Sequence number of the state transition for the alert
PDB_NAME VARCHAR2 (128)
Name of the Pluggable Database that posted the alert
CON_ID NUMBER

Container ID of the pluggable database that posted the alert
Query Text

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


SELECT SEQUENCE_ID
,      REASON_ID
,      OWNER
,      OBJECT_NAME
,      SUBOBJECT_NAME
,      OBJECT_TYPE
,      REASON
,      TIME_SUGGESTED
,      CREATION_TIME
,      SUGGESTED_ACTION
,      ADVISOR_NAME
,      METRIC_VALUE
,      MESSAGE_TYPE
,      MESSAGE_GROUP
,      MESSAGE_LEVEL
,      HOSTING_CLIENT_ID
,      MODULE_ID
,      PROCESS_ID
,      HOST_ID
,      HOST_NW_ADDR
,      INSTANCE_NAME
,      INSTANCE_NUMBER
,      USER_ID
,      EXECUTION_CONTEXT_ID
,      ERROR_INSTANCE_ID
,      RESOLUTION
,      STATE_TRANSITION_NUMBER
,      PDB_NAME
,      CON_ID
FROM SYS.CDB_ALERT_HISTORY_DETAIL;

Dependencies

[top of page]

SYS.CDB_ALERT_HISTORY_DETAIL does not reference any database object

SYS.CDB_ALERT_HISTORY_DETAIL is referenced by following:

SchemaPUBLIC
SynonymCDB_ALERT_HISTORY_DETAIL