Viewing the Consumers Who Can Dequeue Messages

Consumers are configured to dequeue messages from a specific queue. In a messaging environment, consumers are represented by subscribers to a queue, and more than one consumer might use a single subscriber.

Consumers can be:

• Applications or users that dequeue and process messages

• Propagations that send messages from one queue to another

• Apply processes that can dequeue messages for custom processes in a messaging environment or dequeue changes to database objects in a replication environment

To view the consumers who can dequeue messages from a specific 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. If necessary, use the search tool to find the queue, and then select it.

6. Select Subscribers in the Actions list.

7. Click Go to open the Subscribers page.

The Subscribers page includes the following information about each subscriber to the queue:

• The Name field contains the name of the subscriber.

• The Address field is typically populated if the subscriber is a propagation that sends messages to another queue. The Address field shows the name of the queue that receives the messages.

• The Database Link field shows the database link to a remote database if the subscriber is at the remote database.

• The Rule field shows the rule used by the subscriber. Rules can determine which messages are dequeued by the subscriber. Some subscribers do not use rules.

• The Transformation field shows the transformation used by the subscriber. Transformations modify messages while they are being dequeued. Some subscribers do not use transformations.