Wednesday, 21 August 2013

Oracle Session Numbers Going Crazy - What is the best strategy to over come this issue?

Oracle Session Numbers Going Crazy - What is the best strategy to over
come this issue?

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 ?

No comments:

Post a Comment