Oracle8i Reference
Release 2 (8.1.6)

A76961-01

Library

Product

Contents

Index

Prev Up Next

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 


Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index