Is it recommended to enable DB connection pooling on the Siebel environment? (Doc ID 1933697.1)

Last updated on MAY 05, 2016

Applies to:

Siebel CRM - Version 7.0.4 SIS [14068] and later
Information in this document applies to any platform.
**** Checked for Relevance on 05-May-2016 ****

Goal

We have recently been given the recommendation from our DBA team that we should enhance the db connection pooling for our siebel enterprise in production as a measure to reduce the CPU usage on the server hosting the database.

Please let us know :-

1> Is it beneficial and feasible to implement the db connection pooling for a siebel enterprise in production.
2> What are the risk factors/trade off that will come up with such functionality.
3> If it is advisable what is the approach and how to implement the same.

 

Solution

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