My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.