RE: Oracle AQ Question
- From: "Wang, Tao" <twang@xxxxxxxxxx>
- To: "Thomas Day" <tomdaytwo@xxxxxxxxx>
- Date: Thu, 11 Mar 2010 10:47:42 -0500
Check metalink Doc -- Message Status Becomes UNDELIVERABLE When
Propagation Schedule Runs [ID 275088.1].
It will give you some ideas where to check. Good luck..
Tao
From: Thomas Day [mailto:tomdaytwo@xxxxxxxxx]
Sent: Thursday, March 11, 2010 10:41 AM
To: Wang, Tao
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Oracle AQ Question
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:
