You can set the minimum and maximum number of JDBC connection pools. How you configure these depends largely on the number of Planning users accessing the relational database. For example, you can specify the minimum connection number in JDBC connection pool as one, and the maximum as five. Doing this 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 2 and a maximum of 10. The Planning application does not function correctly if you lower the maximum JDBC_MAX_CONNECTIONS to less than 2.
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