We're running a web app using JBoss 4.0.3 and Oracle 10.2.0.3.
We had an issue last October when we switched from Oracle 9i to 10G that our connections were rapidly increasing causing the system to slow down and eventually stop working.
We followed these wiki entries at that time for cleaning up open connections and correcting the configuration:
Using those, we did close all open connections but eventually the problem was the Oracle database driver we were using with the application. We were still using the 9i driver. When we switched to the 10.2.0.3 driver, it worked well.
Two weeks ago, our DBAs installed the Oracle Critical Patch Update (which wasn't supposed to affect us) and we now have the same problem again. We did the following steps:
1. Turned back on debug mode for open connections but nothing showed up that was helpful
2. Downloaded the newest version of the Oracle jar for our JDK, odjbc5.jar which is for version 188.8.131.52 I believe. I found some sites that said Oracle recommends always using the most updated version of their drivers as long as you're using Oracle version 9.0.1 or higher.
After these steps, the problem is still there and we are dumbfounded. One thing to note is that we're very limited with our environments so production doesn't mimic developement(our client has all control). This makes it harder to load test these things.
Does anyone have any ideas, suggestions, or past issues like this?