|Processed messages in queue [message #191818]
||Fri, 08 September 2006 04:25
Registered: September 2006
Location: Moscow, Russia
Came across puzzle when do dequeue messages:
We want to dequeue all messages for particular consumer.
We do dequeue with no_wait, first_message, consumer_name.
It works all right.
All messages for specified consumer is dequeued.
Immediately querying view AQ$QUEUE_T_QUEUE_x - we can see that dequeued messages are in 'PROCESSED' status
and in 'READY' status in table QUEUE_T_QUEUE_x.
Wait some Time - query view/table again - and we dont see them any more in the queue.
Queue retention is set to 25 hours. So messages deleted from queue much more fast.
The main question is - what does the
Time between message is in 'PROCESSED' state after dequeue
time it disappears from queue
We see different Time on different instances.
We guess that may be it's Queue Monitor that responsible for that?
Does anybody know what is going on and how to control it?
Any help is appreciated!
Thanks in advance!