Connection Pooling not working as expected
Last updated on MARCH 02, 2017
Applies to:Siebel Financial Services CRM - Version: 18.104.22.168 SIA  - Release: V7
Information in this document applies to any platform.
The environment had 4 application servers running FINSObjMgr_sso and the following setting for the OM component:
With the above, it is expected to have no more then 1900 DB connections:
4 * 300 = 1200 Share db connections for primary login.
15 * 4 * 10 = 600 Specialized EAI shared db connections
Other components : 100
Regardless of the above, for 3000 users, they had 3500 db connections and it seamed like connection pooling was not working. The OM logs showed as if connection pooling worked as expected (connections were reused from the pool).
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