Skip Headers
DBMS_ALERT_INFO describes registered alerts.
DBMS_ALERT_INFO
NAME
VARCHAR2(30)
NOT NULL
Name of the alert
SID
Session ID of a session waiting for this alert
CHANGED
VARCHAR2(1)
Boolean flag to indicate that an alert has been signaled. Y: alert signaled, N: no alert.
Y
N
MESSAGE
VARCHAR2(1800)
Optional message passed by signaler