Static Data Dictionary Views, 261 of 452

Oracle8i Reference
Release 2 (8.1.6)
A76961-01

Static Data Dictionary Views, 261 of 452

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

Oracle

Copyright © 1999 Oracle Corporation.
All Rights Reserved.