Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
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 |