| Processed messages in queue [message #191818] |
Fri, 08 September 2006 04:25 |
msc_guest
Messages: 1
Registered: September 2006
Location: Moscow, Russia
|
Junior Member |
|
|
Hello!
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
and
time it disappears from queue
depend on?
We see different Time on different instances.
AQ_TM_PROCESSES=10
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!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
