Connection Pool

- A connection pool contains information about the connection between Oracle BI Server and the data source. The connection pool contains data source name information used to connect to a data source, the number of connections allowed, timeout information, and other connectivity-related administrative details.
- Connection pools allow multiple concurrent data source requests (queries) to share a single database connection, reducing the overhead of connecting to a database.
- For each connection pool, you must specify the maximum number of concurrent connections allowed.
- After this limit is reached, the Oracle BI Server routes all other connection requests to another connection pool or, if no other connection pools exist, the connection request waits until a connection becomes available.
 - It is recommended that you create a dedicated connection pool for initialization blocks. There is at least one connection pool for each data source.

 

View the original article here