Hello guys. Under what circumstances could we get more than MaxActive sessions in the database if DBCP is our only means of access to it?
This is our current configuration and it's surpassing 160 Oracle sessions at times when it shouldn't go beyond 32 (our current value for MaxActive). DB = Oracle 11g Data access via spring famework. Thanks in advance. <bean id="dwDataSource" class="org.apache.commons.dbcp.BasicDataSource" p:url="${dw.db.url}" p:username="${dw.db.username}" p:password="${dw.db.password}" p:driverClassName="${dw.db.driverClassName}" init-method="createDataSource" destroy-method="close"> <property name="initialSize" value="${dw.db.initial.connection.size}" /> <property name="maxActive" value="${dw.db.max.connection.size}" /> <!-- As part of perf testing, saw a bottleneck in the dw hence commiting these two params <property name="testOnBorrow" value="true" /> <property name="validationQuery" value="${dw.db.validation.query}" /> --> <property name="minEvictableIdleTimeMillis" value="900000" /> <property name="minIdle" value="${dw.db.minIdle.connections}" /> <property name="maxIdle" value="${dw.db.maxIdle.connections}" /> <property name="timeBetweenEvictionRunsMillis" value="1200000" /> </bean> dw.db.url=jdbc:oracle:thin:someDB/somePass@someHost:1522:SomeInstance dw.db.username=someUser dw.db.password=somePass dw.db.driverClassName=oracle.jdbc.OracleDriver dw.db.allowed.operations=select dw.db.schema=1|COMMON_APP_VIEWS_01, 81|COMMON_APP_VIEWS_81 dw.db.maxRows=500 dw.db.type=ORACLE dw.db.validation.query=select 1 from dual dw.db.initial.connection.size=4 dw.db.max.connection.size=32 dw.db.minIdle.connections=4 dw.db.maxIdle.connections=4 What other info would you need? Rene Romero Benavides Administrador de Bases de Datos para Command Center +52(55) 11020460 Ext. 6432 | Office +52 1 5545664012 | Mobile www.omnitracs.com/mx<http://www.omnitracs.com/mx> Register today! www.omnitracs.com/outlook<http://www.omnitracs.com/outlook> <https://outlook.office.com/owa/service.svc/s/GetFileAttachment?id=AAMkAGM2NWIyZGFmLWZhMTYtNDUzNC04YzQ5LWEwOTA1Zjk4MTY3ZgBGAAAAAABp9rw%2F5DvqQ5VNu%2FP5FANvBwCC6JFKXcS6RJy5Q76IhGGqAAAAAAEMAACC6JFKXcS6RJy5Q76IhGGqAACGtmA4AAABEgAQANT3RQAH0VJIrveZGngUUTQ%3D&X-OWA-CANARY=zgTt0gEIPEaHc-Q35K2xD7ADDSE3yNIYLGPJUeTkGumastS1fdcpigPbw4ASyo9SSzPAsJtdi6o>