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>

Reply via email to