DBA_OUTSTANDING_ALERTS

Oracle 11gR1
DBA_OUTSTANDING_ALERTS describes alerts which the server considers to be outstanding.

Column	Datatype	NULL	Description
SEQUENCE_ID	NUMBER		Alert sequence number
REASON_ID	NUMBER	NOT NULL	ID of the alert reason
OWNER	VARCHAR2(30)		Owner of the object on which the alert was issued
OBJECT_NAME	VARCHAR2(513)		Name of the object
SUBOBJECT_NAME	VARCHAR2(30)		Name of the subobject
OBJECT_TYPE	VARCHAR2(64)		Object type
REASON	VARCHAR2(4000)		Reason for the alert
TIME_SUGGESTED	TIMESTAMP(6) WITH TIME ZONE		Time when the alert was last updated
CREATION_TIME	TIMESTAMP(6) WITH TIME ZONE		Time when the alert was first created
SUGGESTED_ACTION	VARCHAR2(4000)		Advice of the recommended action
ADVISOR_NAME	VARCHAR2(30)		Name of the advisor to be invoked for more information
METRIC_VALUE	NUMBER		Value of the related metrics
MESSAGE_TYPE	VARCHAR2(12)		Message type: · Notification · Warning
MESSAGE_GROUP	VARCHAR2(64)		Name of the message group to which the alert belongs
MESSAGE_LEVEL	NUMBER		Message severity level (1 to 32)
HOSTING_CLIENT_ID	VARCHAR2(64)		ID of the client or security group to which the alert relates
MODULE_ID	VARCHAR2(64)		ID of the module that originated the alert
PROCESS_ID	VARCHAR2(128)		Process ID
HOST_ID	VARCHAR2(256)		DNS host name of the originating host
HOST_NW_ADDR	VARCHAR2(256)		IP or other network address of the originating host
INSTANCE_NAME	VARCHAR2(16)		Originating instance name
INSTANCE_NUMBER	NUMBER		Originating instance number
USER_ID	VARCHAR2(30)		User ID
EXECUTION_CONTEXT_ID	VARCHAR2(60)		ID of the threshold of execution
ERROR_INSTANCE_ID	VARCHAR2(142)		ID of an error instance plus a sequence number

Note:

1.

select reason_id, object_name, object_type, reason, creation_time,

suggested_action, message_group

from DBA_OUTSTANDING_ALERTS

order by creation_time desc;

REASON _ID	OBJECT _NAME	OBJECT _TYPE	REASON	CREATION _TIME	SUGGESTED _ACTION	MESSAGE _GROUP
9	UNDO	TABLESPACE	Tablespace [UNDO] is [86 percent] full	2008-08-12 5:19:56.053828 AM -07:00	Add space to the tablespace	Space
9	BUS_TABLES	TABLESPACE	Tablespace [BUS_TABLES] is [85 percent] full	2008-08-09 9:18:30.787179 PM -07:00	Add space to the tablespace	Space
9	BUS_INDEXES	TABLESPACE	Tablespace [BUS_INDEXES] is [88 percent] full	2006-06-11 7:46:39.945133 AM -07:00	Add space to the tablespace	Space

2. The following dictionary views provide information about server alerts:

• DBA_THRESHOLDS lists the threshold settings defined for the instance.
• DBA_OUTSTANDING_ALERTS describes the outstanding alerts in the database.
• DBA_ALERT_HISTORY lists a history of alerts that have been cleared.
• V$ALERT_TYPES provides information such as group and type for each alert.
• V$METRICNAME contains the names, identifiers, and other information about the system metrics.
• V$METRIC and V$METRIC_HISTORY views contain system-level metric values in memory.

Oracle data dictionary views

More Oracle DBA tips, please visit Oracle DBA Tips