ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brice Ruth <bdr...@gmail.com>
Subject Re: Oracle + iBATIS - performance slows to a crawl over time
Date Wed, 16 Mar 2005 15:18:24 GMT
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
<brian.barnett@whitesandsolutions.com> 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

View raw message