| Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 | 
 | 
| 
 | PDF · Mobi · ePub | 
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 |