Data Source Manager: Connection Pool

This page is accessed via Configuration and Administration > System Administration > Data Source Manager. This information can be found on the Pool tab. This screen should only be used by experienced database administrators (DBAs).

Note: Cloud users do not have access to this page. OnPrem users must be a DBA to access this page. These screens should only be used by experienced database administrators (DBAs).

The connection pool provides parameters to initialize either a connection pool managed by Oracle Transportation Management or a dynamic connection pool managed by the application server. The connection pool can be created dynamically or statically when the application server starts. It can be shared across all users of the data source or dedicated to the current user.

Defining a Connection Pool

1. Enter a Description for the pool.
2. Select the Dedicated check box if you want each user to have their own data source pool. Doing so limits queries to only access information
3. Enter a Login Delay. When adding many connections to a database this delay staggers the connection times allowing the database to catch up with all the connections.
4. Enter an Initial Capacity for the number of connections in the pool.
5. Designate when to initialize the pool.
6. Wait Timeout controls how long a thread will wait for a connection to become available before throwing an exception when the pool has reached its maximum capacity.
7. Enter the Maximum Capacity for the number of connections in the data source pool.
8. The Refresh When parameter configures whether or not we ping the connection "On Reserve" (getting a connection from the pool), "On Release" (returning a connection to the pool), "Both", or "Never". The connection is still pinged periodically based on the duration specified in "Refresh Every" parameter.
9. Using the Refresh Every fields, specify in hours, minutes, and seconds how often to Refresh the pool.
10. Enter a Capacity Increment.
11. Select when the pool should Shrink At from the drop-down list.
12. Using the Shrink Every fields, specify in hours, minutes, and seconds how often to shrink the pool.

Name

1. Enter a Name for the pool.
2. Enter a Value for the pool name.
3. Click Save.

After you have entered all the data source pool information, click Save.