VIEW: SYS.V_$DIAG_ALERT_EXT

Source

View Text - Preformatted

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 x$diag_ALERT_EXT

View Text - HTML Formatted

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 X$DIAG_ALERT_EXT