My Oracle Support Banner

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

Last updated on DECEMBER 08, 2020

Applies to:

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

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

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
Symptoms
Cause
Solution
References


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