DBMS_ALERT_INFO describes registered alerts.

Column Datatype NULL Description
NAME VARCHAR2(30) NOT NULL Name of the alert
SID VARCHAR2(30) NOT NULL 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