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>
