PROCESSED Messages remain in Queue Table after a Successful Dequeue

(Doc ID 251737.1)

Last updated on MAY 04, 2017

Applies to:

Oracle Database - Enterprise Edition - Version to [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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms