OBIEE 11.1.1 - Increase the Number of Connection Pool in WebLogic Server

If JDBC (BI) data sources are running out of connections to the relational database then you need to set the maximum number of connections to high value for the following Business Intelligence Enterprise Edition data sources:

Important Note: Reason why the default value maximum capacity size is set to lower value is because it is important to protect database resources. So make sure you have enough resources on the database server (available memory is a constraint). If you increase initial / maximum capacity to very high value, you may exceed the limit of PROCESSES / OPEN_CURSORS on Oracle® Database server.

Data Source Name Default Value Suggested Value
bip_datasource Initial Capacity: 0
Maximum Capacity: 50
Initial Capacity: 0
Maximum Capacity: 100

mds-owsm Initial Capacity: 0
Maximum Capacity: 50

Initial Capacity: 0
Maximum Capacity: 100

Important Note: You need to determine the optimal value for the Maximum Capacity as part of your pre-production performance testing. Once optimal values are determined then set the value of Initial Capacity equal to the value for Maximum Capacity in order to boost performance of JDBC in WebLogic Server web applications.

Warning: Here is the example on how to size open cursors value on Oracle® database, if you have a data source with 100 connections deployed on 2 servers and if you use default Statement Cache Size 10, you may open 2000 (100 x 2 x 10) cursors on your database server for the cached statements. You can increase the open cursors limit in Oracle® database server.

Tip: How-to increase this value:
1. Log in to the WebLogic Server administration console.
2. Select your data source (for example “bip_datasource”), and then click on Connection Pool tab, and then Maximum Capacity.


Post a Comment:
Comments are closed for this entry.