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

VIEW: SYS.INT$DBA_ALERT_HISTORY

Object Details
Object Name: INT$DBA_ALERT_HISTORY
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
SEQUENCE_ID NUMBER
Yes
REASON_ID NUMBER

OWNER VARCHAR2 (128)
OBJECT_NAME VARCHAR2 (513)
SUBOBJECT_NAME VARCHAR2 (128)
OBJECT_TYPE VARCHAR2 (64)
REASON VARCHAR2 (4000)
TIME_SUGGESTED TIMESTAMP(6) WITH TIME ZONE (13)
CREATION_TIME TIMESTAMP(6) WITH TIME ZONE (13)
SUGGESTED_ACTION VARCHAR2 (4000)
ADVISOR_NAME VARCHAR2 (128)
METRIC_VALUE NUMBER

MESSAGE_TYPE VARCHAR2 (12)
MESSAGE_GROUP VARCHAR2 (64)
MESSAGE_LEVEL NUMBER

HOSTING_CLIENT_ID VARCHAR2 (64)
MODULE_ID VARCHAR2 (64)
PROCESS_ID VARCHAR2 (128)
HOST_ID VARCHAR2 (256)
HOST_NW_ADDR VARCHAR2 (256)
INSTANCE_NAME VARCHAR2 (16)
INSTANCE_NUMBER NUMBER

USER_ID VARCHAR2 (128)
EXECUTION_CONTEXT_ID VARCHAR2 (128)
ERROR_INSTANCE_ID VARCHAR2 (142)
RESOLUTION VARCHAR2 (7)
PDB_NAME VARCHAR2 (128)
CON_ID NUMBER

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
,      PDB_NAME
,      CON_ID
FROM SYS.INT$DBA_ALERT_HISTORY;

Dependencies

[top of page]

SYS.INT$DBA_ALERT_HISTORY references the following:

SchemaSYS
ViewDBA_ADVISOR_DEFINITIONS
PL/SQL PackageDBMS_SERVER_ALERT - show dependent code
TableWRI$_ALERT_HISTORY
SYS.INT$DBA_ALERT_HISTORY is referenced by following:

SchemaSYS
ViewDBA_ALERT_HISTORY