We experience dequeue-times of 10 seconds and more. Dequeue Options are "FIRST_MESSAGE", "Wait Forever", "Dequeue Remove". The queue table is defined for multiple recipients, there's only one queue defined on this table. There is an index on MSGID on the queue table. The number of messages in the queue table is well below 100.
When we change dequeue options to "Next Message" the time to dequeue a message is below 1 second, but with "First Message" it goes sometimes up to nearly 20 seconds. The version of the database is 11G.
I don't know if I have supplied enough information, but maybe you have a quick recommendation what we could do about this.
Thanks a lot,
what is the time frequency for your messages to enqueue data into the AQ ?
And what is the data type and size of your payload data (VARCHAR2, CLOB etc) ?
In general, it depends on your requirements if it is ok to handle the data row by row
using NEXT_MESSAGE and not bulkwise.
Normally, using the option FIRST_MESSAGE is not a performance bottleneck.