2
We have a JVM web application which is running on Oracle Application Server and it uses commons-dbcp (http://commons.apache.org/proper/commons-dbcp/) and implicit connection pooling. Our db is Oracle.
Under heavy load oracle session numbers are going crazy and eventually our system guys need to restart our web application servers.
I am not a system guy, I am just a programmer but I just wonder what is the best strategy for caching up this kind of performance problems. We the programmers are using FindBugs for evaluating connection and cursor leaks.
Does migrating to cloud based, high scalable architectures make sense ?
cgon
Posted 2013-08-21T11:02:48.240
Reputation: 71
Besides moving off of Oracle and to something that doesn't...suck? I think this would be a better ServerFault question. – Austin T French – 2013-09-03T13:27:50.753
The DBCP might be misconfigured and the pool might go crazy. Did you check its configuration? Is there a maximum pool limit set? Is the Oracle Database instance a shared or dedicated server (regarding the PGA)? – David Lakatos – 2013-09-04T10:18:18.447