Static Data Dictionary Views, 261 of 452
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.
MESSAGE
VARCHAR2(1800)
Optional message passed by signaler