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'm not a system guy, I'm 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?