5.226 DBA_OUTSTANDING_ALERTS

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(128)

Owner of the object on which the alert was issued

OBJECT_NAME

VARCHAR2(513)

Name of the object

SUBOBJECT_NAME

VARCHAR2(128)

Name of the subobject (for example: partition)

OBJECT_TYPE

VARCHAR2(64)

Object type (for example: table, tablespace)

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(128)

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(128)

User ID

EXECUTION_CONTEXT_ID

VARCHAR2(128)

Execution Context ID

ERROR_INSTANCE_ID

VARCHAR2(142)

ID of an error instance plus a sequence number

STATE_TRANSITION_NUMBER

NUMBER

Sequence number of the state transition for the alert

PDB_NAME

VARCHAR2(128)

PDB name

CON_ID

NUMBER

NOT NULL

The ID of the container to which the data pertains. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data