PROCESSED Messages remain in Queue Table after a Successful Dequeue
Last updated on MAY 04, 2017
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 to 10.2.0.1 [Release 8.1.7 to 10.2]
Information in this document applies to any platform.
After successfully dequeuing messages from a queue, the messages remain in the queue table with a message state of PROCESSED.
The PROCESSED messages are not removed even after the retention time for the queue has passed.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms