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 184.108.40.206.0 and later
Information in this document applies to any platform.
On : 220.127.116.11.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
WHERE (FLOW_ID = :1 ) FOR UPDATE
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