DB Connection Pooling Causing Inactive Blocking Database Sessions and Application CRASH
(Doc ID 1421011.1)
Last updated on APRIL 30, 2018
Applies to:Siebel CRM - Version 126.96.36.199 SIA  and later
Information in this document applies to any platform.
Some INSERT INTO statements executed on Siebel CRM tables (e.g. the S_AUDIT_ITEM table) are taking too much time to complete, this is an intermitent issue since not all INSERT INTO statements executed on this table show poor performance.
In certain cases Siebel Object Manager crashes.
Example of the call stack at the crash (Windows OS, EAI Object Manager task was executing Integration Workflow Process that implements a Siebel Inbound Web Service of Siebel Loyalty ):
All INSERT INTO statements executed on Siebel CRM Tables table should show a consistent and acceptable performance.
No Siebel Object Manager crashes occur.
Siebel DB Connection Pooling was enabled in the customer's environment
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!