My Oracle Support Banner

Deq_time Column not Updated when Message Dequeued (Doc ID 1293709.1)

Last updated on OCTOBER 09, 2023

Applies to:

Oracle SOA Suite - Version and later
Information in this document applies to any platform.


The column DEQ_TIME for the queue_table 'WF_BPEL_QTAB' is not being updated after messages have been successfully dequeued by the WF_BPEL_Q subscriber from a queue with the same_name and the messages for this subscriber remained in READY state.
This means that because the message remains in a Ready state then the AQ processes will not remove it from the queue, even though it has already been consumed. Over time these messages may cause file system issues as data remains stored in rdbms tablespaces which directly relates to file system file growth on hard disk drives - also affecting the rdbms due to performance issues.





To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.