Oracle9i Application Developer's Guide - Advanced Queuing Release 1 (9.0.1) Part Number A88890-02 |
|
Administrative Interface: Views, 13 of 21
AQ$<queue_table_name>_S
This is a view of all the subscribers for all the queues in any given queue table. This view is generated when the queue table is created and is called aq$<queue_table_name>_s
. This view is used to query subscribers for any or all the queues in this queue table. Note that this view is only created for 8.1-compatible queue tables. This view also displays the transformation for the subscriber if it was created with one.
For queues created in 8.1-compatible queue tables, this view provides functionality that is equivalent to the dbms_aqadm.queue_subscribers()
procedure. For these queues, it is recommended that the view be used instead of this procedure to view queue subscribers.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|