DB Connection Pooling Causing Inactive Blocking Database Sessions and Application CRASH (Doc ID 1421011.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 8.2.2.3 SIA [23021] and later
Information in this document applies to any platform.

Symptoms

---------------
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 ):

 


EXPECTED BEHAVIOR
-----------------------
All INSERT INTO statements executed on Siebel CRM Tables table should show a consistent and acceptable performance.

No Siebel Object Manager crashes occur.

Changes

Siebel DB Connection Pooling was enabled in the customer's environment

Cause

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