Hi,

I have a jdk 1.4 application which was talking to a database on an
Oracle 8.1.7 Server running on the same Solaris box.

I moved the database to another box (AIX), running Oracle 9.2.0.4.



The performance of the application has deteriorated appallingly.



I've put in some timings and in some seconds the java app is taking 10
seconds to simply close a CallableStatement !



I was running an older jdbc (oracle12.zip), but have replaced with the
ojdbc14.zip that comes with Oracle 9.2.0.4

(from a Solaris Oracle server install).



Q: What could possibly cause these performance problems simply by upgrading
my Oracle server ?



Q: Should I be using the ojdbc14.zip that came with my Oracle 9.2.0.4 on AIX
?, or is this the same as the ojdbc.zip that comes with Oracle 9.2.0.4 on
Solaris.



Any help appreciated,

Thanks

Peter Groarke


Oracle LazyDBA home page