Viewing Persistent Queue Statistics

If you are using persistent messaging mode, then messages are stored in queue table on hard disk. This topic describes viewing statistics for messages that were enqueued in persistent mode into a persistent queue.

To view persistent queue statistics:

In Oracle Enterprise Manager, log in to the database as the Oracle Streams administrator.
Go to the Database Home page.
Click Data Movement to open the Data Movement subpage.
Click Manage Advanced Queues to open the Streams page.
Select the queue that contains the messages. If necessary, use the search tool to find the queue, and then select it.
Select Queue Statistics in the Actions list.
Click Go.
On the Queue Statistics page, click Message Statistics to view the persistent queue statistics for the queue.

The message statistics show the number of messages in each state in the persistent queue. They also show the total wait time and the average wait time for messages to be dequeued.

Note:

Messages can also be enqueued in buffered mode. In this case, the messages are stored in memory in a buffered queue. See "Viewing Buffered Queue Statistics" for information about viewing statistics for these messages.
You can also query the V$AQ dynamic performance view for queue statistics.

Viewing Persistent Queue Statistics

Related Topics