Connection pools

Connection pools contain a cached set of database connections that can be used for incoming database connection requests. You configure a connection pool to accommodate the number of concurrent users and transaction load expected, Depending on your environment, the connection pool settings in one or more files must be configured for correct connectivity to the database. Connection pool names are case-sensitive.

The recommended setting for minimum connections is 10. The recommended setting for maximum connections is 100. A setting of 100 maximum connections is common for a JVM that is not expected to exceed 500 concurrent users. You can modify the connection pool setting on the data source defined for IBM TRIRIGA.
Connection pool settings File location
Oracle Database trace levels

[tririga_root]\config\TRIRIGAMIDDLEWARE.properties

For example, C:\Tririga\config\TRIRIGAMIDDLEWARE.properties