Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
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 |