DB Connection Pooling Causing Inactive Blocking Database Sessions and Application CRASH
Last updated on APRIL 30, 2018
Applies to:Siebel CRM - Version 18.104.22.168 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
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