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_OUTSTANDING_ALERTS

Object Details

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

Description of all outstanding alerts

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SEQUENCE_ID	NUMBER			Alert sequence number
REASON_ID	NUMBER		Yes	Alert reason id
OWNER	VARCHAR2	(128)		Owner of 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 created
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 threshold of execution
ERROR_INSTANCE_ID	VARCHAR2	(142)		ID of an error instance plus a sequence number
STATE_TRANSITION_NUMBER	NUMBER			Alert State Transition number, incremented for each state transition
PDB_NAME	VARCHAR2	(128)		Name of the Pluggable Database that posted the alert
CON_ID	NUMBER		Yes	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
,      STATE_TRANSITION_NUMBER
,      PDB_NAME
,      CON_ID
FROM SYS.DBA_OUTSTANDING_ALERTS;

Dependencies

[top of page]

SYS.DBA_OUTSTANDING_ALERTS references the following:

SYS: DBMS_SERVER_ALERT - show dependent code; INT$DBA_OUTSTANDING_ALERTS

SYS.DBA_OUTSTANDING_ALERTS is referenced by following:

PUBLIC: DBA_OUTSTANDING_ALERTS
SYS: DBMS_SPACE - show dependent code