SOA Server Having Large Hogging Threads And Becomes Unstable (Doc ID 2734117.1)

Last updated on AUGUST 11, 2023

Applies to:

Symptoms

On : 12.2.1.3.0 version, BPEL Service Engine

SOA server having large hogging threads and becomes unstable

SOA managed server once started becomes unstable after few hours and has large number of hogging threads.
On DB side we are seeing below query which is running concurrently and causing CPU spikes:

SELECT FLOW_ID, ACTIVE_COMPONENT_INSTANCES, ADMIN_STATE, COMPOSITE_SCA_ENTITY_ID, CONVERSATION_ID, FLOW_CORRELATION_ID, CREATED_BY, CREATED_TIME, ECID, PROPERTIES, PURGEABLE, RECOVERABLE_FAULTS, RESEQUENCER, SCA_PARTITION_ID, TENANT_ID, TEST_CASE, TEST_RUN_ID, TEST_RUN_NAME, TEST_SUITE, TITLE, UNHANDLED_FAULTS, UPDATED_BY, UPDATED_TIME, VERSION
FROM SCA_FLOW_INSTANCE
WHERE (FLOW_ID = :1 ) FOR UPDATE
 

Cause

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