Viewing Buffered Queue Statistics

You can use Enterprise Manager to view statistics for a buffered queue that is used by a capture process, propagation, or apply process in your replication environment. In an Oracle Streams replication environment that uses capture processes to capture changes, each capture process enqueues changes into the buffered queue portion of its queue. The changes remain in buffered queues as they are propagated from one queue to another, and apply processes dequeue the changes from a buffered queue.

To view buffered queue statistics: 

1. In Oracle Enterprise Manager, log in to the database as the Oracle Streams administrator.

2. Go to the Database Home page.

3. Click Data Movement to open the Data Movement subpage.

4. Click Manage Advanced Queues in the Streams section.

   The Streams page appears.

5. Select the queue that you want to monitor. If necessary, use the search tool to find the queue, and then select it.

6. Select Queue Statistics in the Actions list.

7. Click Go to open the Queue Statistics page.

8. Click Buffered Queue Statistics to open the Buffered Queue Statistics subpage.

This Buffered Queue Statistics subpage includes the following information about the buffered queue portion of the selected queue:

• Information about the number of changes in the queue and the number of changes that have spilled from memory onto disk.

• The number of changes enqueued by local capture processes. When the capture process is local, the Sender Queue field is empty.

• The number of changes captured by remote capture processes at a different database and sent to the buffered queue. When a capture process is remote, the Sender Queue field contains the queue and database from which the changes were sent.

• The number of changes dequeued by local apply processes from the buffered queue.

• The number of changes sent by propagations from the buffered queue to a different queue.