Home » Server Options » Streams & AQ » Processed messages in queue
Processed messages in queue [message #191818] Fri, 08 September 2006 04:25
Messages: 1
Registered: September 2006
Location: Moscow, Russia
Junior Member

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
depend on?
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!
Previous Topic: How can we retrieve dropped Table with Oracle stream Capture option
Next Topic: 9i to 10g replication
Goto Forum:

Current Time: Sat Feb 24 11:23:19 CST 2024