Deq_time Column not Updated when Message Dequeued
Last updated on APRIL 03, 2018
Applies to:Oracle SOA Suite - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
***Checked for relevance on 08-November-2013***
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.
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