Datasource Connection Pool Size

OIPA and Cycle leverages 4 data sources for different purpose. The DB connection pools size can be adjusted based on the usage and number of open cursors/session for the Cycle run. The recommended DB connections per datasource is 50 connections per JVM. It can be set lowered if the connections are unused. It can be determined by running profiling tools or database diagnostic reports to see how many number of active sessions or connections are used during peak load times.

• ADMINSERVERDS

• ADMINSERVERSEARCHDS

• ADMINSERVERRESOURCEDS

• ADMINSERVERREADONLYDS