[Home] [Help] [Dependency Information]
Object Name: | V_$DIAG_ALERT_EXT |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ADDR | RAW | (8) | ||
INDX | NUMBER | |||
INST_ID | NUMBER | |||
CON_ID | NUMBER | |||
ADR_PATH_IDX | VARCHAR2 | (445) | ||
ADR_HOME | VARCHAR2 | (445) | ||
ORIGINATING_TIMESTAMP | TIMESTAMP(9) WITH TIME ZONE | (20) | ||
NORMALIZED_TIMESTAMP | TIMESTAMP(9) WITH TIME ZONE | (20) | ||
ORGANIZATION_ID | VARCHAR2 | (67) | ||
COMPONENT_ID | VARCHAR2 | (67) | ||
HOST_ID | VARCHAR2 | (67) | ||
HOST_ADDRESS | VARCHAR2 | (49) | ||
MESSAGE_TYPE | NUMBER | |||
MESSAGE_LEVEL | NUMBER | |||
MESSAGE_ID | VARCHAR2 | (67) | ||
MESSAGE_GROUP | VARCHAR2 | (67) | ||
CLIENT_ID | VARCHAR2 | (67) | ||
MODULE_ID | VARCHAR2 | (67) | ||
PROCESS_ID | VARCHAR2 | (35) | ||
THREAD_ID | VARCHAR2 | (67) | ||
USER_ID | VARCHAR2 | (67) | ||
INSTANCE_ID | VARCHAR2 | (67) | ||
DETAILED_LOCATION | VARCHAR2 | (163) | ||
UPSTREAM_COMP_ID | VARCHAR2 | (103) | ||
DOWNSTREAM_COMP_ID | VARCHAR2 | (103) | ||
EXECUTION_CONTEXT_ID | VARCHAR2 | (103) | ||
EXECUTION_CONTEXT_SEQUENCE | NUMBER | |||
ERROR_INSTANCE_ID | NUMBER | |||
ERROR_INSTANCE_SEQUENCE | NUMBER | |||
MESSAGE_TEXT | VARCHAR2 | (2051) | ||
MESSAGE_ARGUMENTS | VARCHAR2 | (515) | ||
SUPPLEMENTAL_ATTRIBUTES | VARCHAR2 | (515) | ||
SUPPLEMENTAL_DETAILS | VARCHAR2 | (515) | ||
PARTITION | NUMBER | |||
RECORD_ID | NUMBER | |||
FILENAME | VARCHAR2 | (515) | ||
LOG_NAME | VARCHAR2 | (67) | ||
PROBLEM_KEY | VARCHAR2 | (553) | ||
VERSION | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ADDR
, INDX
, INST_ID
, CON_ID
, ADR_PATH_IDX
, ADR_HOME
, ORIGINATING_TIMESTAMP
, NORMALIZED_TIMESTAMP
, ORGANIZATION_ID
, COMPONENT_ID
, HOST_ID
, HOST_ADDRESS
, MESSAGE_TYPE
, MESSAGE_LEVEL
, MESSAGE_ID
, MESSAGE_GROUP
, CLIENT_ID
, MODULE_ID
, PROCESS_ID
, THREAD_ID
, USER_ID
, INSTANCE_ID
, DETAILED_LOCATION
, UPSTREAM_COMP_ID
, DOWNSTREAM_COMP_ID
, EXECUTION_CONTEXT_ID
, EXECUTION_CONTEXT_SEQUENCE
, ERROR_INSTANCE_ID
, ERROR_INSTANCE_SEQUENCE
, MESSAGE_TEXT
, MESSAGE_ARGUMENTS
, SUPPLEMENTAL_ATTRIBUTES
, SUPPLEMENTAL_DETAILS
, PARTITION
, RECORD_ID
, FILENAME
, LOG_NAME
, PROBLEM_KEY
, VERSION
FROM SYS.V_$DIAG_ALERT_EXT;
|
|
|