Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

DBMS_ALERT_INFO

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