Views for Queues and Queue Tables

• DBA_QUEUE_SCHEDULES This view displays all propagation schedules in the database.

• DBA_QUEUE_SUBSCRIBERS This view displays all subscribers on all queues in the database.

• DBA_QUEUE_TABLES This view displays information about the owner instance for a queue table. A queue table can contain multiple queues. In this case, each queue in a queue table has the same owner instance as the queue table.

• DBA_QUEUES This view displays the operational characteristics of every queue in a database.

• V$BUFFERED_PUBLISHERS This view displays performance information about all the publishers in the database instance who enqueue messages to the buffered queue. There is one row for each publisher. The information contains statistical data on message queuing along with the current state of the publisher. Typically, the publisher is the capture process.

• V$BUFFERED_QUEUES This view displays performance information about all buffered queues in the database instance.

• V$BUFFERED_SUBSCRIBERS This view displays performance information about all the subscribers in the database instance who dequeue messages from the buffered queue. There is one row for each subscriber. Typically, the subscriber is the apply process.