1. Administrator's Guide
  2. Getting Started with Planning
  3. Setting Application and System Properties
  4. Configuring JDBC Connection Pooling

Configuring JDBC Connection Pooling

You can set the minimum and maximum number of JDBC connection pools. How you configure these depends largely on the number of Oracle Hyperion Planning users accessing the relational database. For example, you can specify the minimum connection number in the JDBC connection pool as one and the maximum as five. Doing so creates one connection when a user logs on to Planning. An additional connection is created for the next four users who log on to Planning, resulting in a total of five connections. Additional users who log on share the five connections.

The JDBC connection settings are set by default to a minimum of two and a maximum of ten. The Planning application does not function correctly if you reduce the maximum JDBC_MAX_CONNECTIONS to fewer than two.

To reconfigure JDBC connection pool parameters, change the minimum and maximum property values:

  • JDBC_MIN_CONNECTIONS

  • JDBC_MAX_CONNECTIONS

To optimize performance, Oracle recommends these settings:

  • JDBC_MIN_CONNECTIONS=10

  • JDBC_MAX_CONNECTIONS=45