Re: Oracle AQ Question
- From: Thomas Day <tomdaytwo@xxxxxxxxx>
- To: "Wang, Tao" <twang@xxxxxxxxxx>
- Date: Thu, 11 Mar 2010 10:41:27 -0500
Message state is UNDELIVERABLE
On Wed, Mar 10, 2010 at 3:39 PM, Wang, Tao <twang@xxxxxxxxxx> wrote:
> After you enqueue the message, you should see in the source queue that
> the message is in "READY" state. After propagation, the state in the source
> queue should be "PROCESSED".. So what is your output of the following query
> *? *
>
> select queue, msg_id, msg_state, consumer_name from
> <queue_owner>.AQ$<QUEUE_NAME>
>
>
>
> my understanding is that If you have an expiration defined in the message
> and the message has not be processed by all consumers within the expiration
> period, the message will be put into exception queue. By default the
> expiration is NEVER EXPIRE, and only after all consumers processed the
> message and the retention period passed, the message will be removed from
> the source queue…
>
>
>
> Tao
>
>
>
Other related posts:
