If its the same application, with the only difference being your JDBC driver, I would be highly suspicious of that driver, first. Assuming that your DataSource configuration is identical between the two applications (other than pointing to different databases & using different drivers).
I've heard mention of the Oracle 10g driver being quite a bit better than previous versions ... I don't have any particular experience with it, but you might want to give that a shot ... whatever the most recent JDBC driver for Oracle is. Other than that, you may want to look at some profiling tools. If I recall correctly, P6Spy can help you there. On Tue, 15 Mar 2005 16:18:10 -0700, Brian Barnett <[EMAIL PROTECTED]> wrote: > (Sorry if this double posts. Having problems with other email account.) > Hello, > Hoping someone can give us some suggestions on how to fix a problem we are > facing. We have a Struts web app that runs against both MS SQL Server and > Oracle. MS SQL Server runs fine. When we run it against Oracle, the > performance slowly degrades until the web app basically stops functioning. > When we restart Tomcat, everything works fine again for awhile. > > We are not sure if there are any specific steps to duplicate, as our beta > testers just "use the app" and then begin to see the problem. > > Does anyone have any suggestions on how we can troubleshoot this? > > Tomcat 5.0.28 > iBATIS 2.0 build 274 > Oracle 9.2.0.x > Oracle Thin driver (ojdbc14.jar) > > TIA, > Brian Barnett >