How to check the default values for a particular queue?
Hi All,
I got to know that : State EXPIRED for messages means the message was not successfully processed (dequeued) in either :
a) the time specified by message_properties_t.expiration while executing dbms_aq.enqueue or
b) the maximum number of dequeue attempts (max_retries) specified for the queue while executing dbms_aqadm.create_queue.
whereas State 'READY' means the message is ready to be processed, i.e., either the delay time of the message has passed or the message did not have a delay time specified.
We are observing a different behavior in two environments where for the same queue, the messages are lying in READY state in one environment, but are getting 'EXPIRED' in a second environment.
0