Query on MEDIATOR_DEFERRED_MESSAGE Table Is Executed Every 2 Seconds Even When Not Using Mediator in Any Composite

(Doc ID 2412960.1)

Last updated on JULY 02, 2018

Applies to:

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

Goal

The following query on MEDIATOR_DEFERRED_MESSAGE table is executed every 2 seconds even when not using mediator in any composite:

SELECT CASE_ID, CASE_INFO, COMPONENT_DN, COMPONENT_STATUS, CONTAINER_ID, CREATION_DATE, FLOW_ID, INSTANCE_CREATED, IS_EVENT, LOCK_TIME, MSG_ID, MSG_RECEIVED_TIME, OPERATION, DUMMY1, PRIORITY, QNAME_LOCAL_PART, QNAME_NAMESPACE, SCA_PARTITION_ID, SOURCE_URI, STATUS FROM MEDIATOR_DEFERRED_MESSAGE WHERE (((STATUS = ?) AND (LOCK_TIME = ?)) AND (CONTAINER_ID = ?)))

Is there any way to reduce the frequency of this query?

 

Solution

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