Significance of jdbc properties "oraclePool.initSize", "oraclePool.MaxSize"

Technote (FAQ)


Question

Significance of jdbc properties "oraclePool.initSize", "oraclePool.MaxSize". How to check number of connections?

Answer

oraclePool.initsize is the minimum number of connection with which oracle pool will be opened with. It also means, At no point of time oracle connection should drop below this value for a JVM.

When JVM(agent/integration) is ideal then system will delete unused connection. But while deleting if connection goes below initSize then system will create new connection.

oraclePool.MaxSize is the maximum number of connection for the pool.


Query used to observe the number of connection.
select * from v$session where username='<provide_the_user_name>';

You can try logging Oracle with some different user to execute this query, so that,current session is not counted.


Rate this page:

(0 users)Average rating

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

Machine Translation

Content navigation