Significance of jdbc properties "oraclePool.initSize",

Technote (FAQ)


Question

How to check number of connections in Sterling Selling and Fulfillment suite?

Answer

oraclePool.initsize is the minimum number of connections with which Oracle pool will be opened. It also means, that at no point in time should the Oracle connection drop below this value for a JVM.
When JVM (agent/integration) is ideal, then the system will delete unused connections. But while deleting, if connection goes below initSize, then system will create new connection.

Query used to observe the number of connections in Oracle:

select count(*) from v$session where username='<provide_the_user_name>';

Note: You can try logging in to Oracle with some different user to execute this query so that the current session does not get counted.

Document information


More support for:

Sterling Selling and Fulfillment Suite
Maintenance

Software version:

All

Operating system(s):

All

Software edition:

All Editions

Reference #:

1612406

Modified date:

2012-12-20

Translate my page

Content navigation