Viewing the Messages in a Queue

You can view the messages in a queue to ensure that an application is enqueuing messages correctly or to see which messages are currently ready to be dequeued or propagated to another queue.

To view the messages currently stored in a queue: 

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 to open the Streams page.

5. Select the queue that contains the messages. If necessary, use the search tool to find the queue, and then select it.

6. Select Messages in the Actions list.

7. Click Go in the Search tool.

8. On the Messages page, click Go. The messages are listed.

9. Click the number link in the Consumers In Different States field to view the consumers of a message. A consumer might be a propagation that sends the message to a different queue or an application that dequeues the message.