eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: SYS.DBA_ALERT_HISTORY_DETAIL

Object Details

Object Name:	DBA_ALERT_HISTORY_DETAIL
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

Detailed alert history

[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.DBA_ALERT_HISTORY_DETAIL;

Dependencies

[top of page]

SYS.DBA_ALERT_HISTORY_DETAIL references the following:

SYS: DBMS_SERVER_ALERT - show dependent code; INT$DBA_ALERT_HISTORY_DETAIL

SYS.DBA_ALERT_HISTORY_DETAIL is referenced by following:

PUBLIC: DBA_ALERT_HISTORY_DETAIL