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

VIEW: SYS.CDB_ALERT_ARGUMENTS

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

Message Id and arguments of outstanding alerts in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
SEQUENCE_ID NUMBER

Alert sequence number
REASON_MESSAGE_ID NUMBER

Id of alert reason message
REASON_ARGUMENT_COUNT NUMBER

Number of alert reason message arguments
REASON_ARGUMENT_1 VARCHAR2 (581)
First argument of alert reason message
REASON_ARGUMENT_2 VARCHAR2 (581)
Second argument of alert reason message
REASON_ARGUMENT_3 VARCHAR2 (581)
Third argument of alert reason message
REASON_ARGUMENT_4 VARCHAR2 (581)
Fourth argument of alert reason message
REASON_ARGUMENT_5 VARCHAR2 (581)
Fifth argument of alert reason message
ACTION_MESSAGE_ID NUMBER

Id of alert action message
ACTION_ARGUMENT_COUNT NUMBER

Number of alert action message arguments
ACTION_ARGUMENT_1 VARCHAR2 (128)
First argument of alert action message
ACTION_ARGUMENT_2 VARCHAR2 (128)
Second argument of alert action message
ACTION_ARGUMENT_3 VARCHAR2 (128)
Third argument of alert action message
ACTION_ARGUMENT_4 VARCHAR2 (128)
Fourth argument of alert action message
ACTION_ARGUMENT_5 VARCHAR2 (128)
Fifth argument of alert action message
CON_ID NUMBER

container id
Query Text

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


SELECT SEQUENCE_ID
,      REASON_MESSAGE_ID
,      REASON_ARGUMENT_COUNT
,      REASON_ARGUMENT_1
,      REASON_ARGUMENT_2
,      REASON_ARGUMENT_3
,      REASON_ARGUMENT_4
,      REASON_ARGUMENT_5
,      ACTION_MESSAGE_ID
,      ACTION_ARGUMENT_COUNT
,      ACTION_ARGUMENT_1
,      ACTION_ARGUMENT_2
,      ACTION_ARGUMENT_3
,      ACTION_ARGUMENT_4
,      ACTION_ARGUMENT_5
,      CON_ID
FROM SYS.CDB_ALERT_ARGUMENTS;

Dependencies

[top of page]

SYS.CDB_ALERT_ARGUMENTS does not reference any database object

SYS.CDB_ALERT_ARGUMENTS is referenced by following:

SchemaPUBLIC
SynonymCDB_ALERT_ARGUMENTS