Oracle speed issue between 8i and 9i

My company has used Oracle 8i quite extensively, and have started to look at 9i. We have noticed a huge degradation in performance from 8i to 9i (where both of these databases are setup using a default installation). A set of read, calculate and write which was taking in the order of 10 seconds on 8i, now takes approx 6 minutes on 9i. Our application has a large number of small queries that are being executed during this process and it's not really possible at this stage to re-write this process.

Our application is written in Java, and is using a standard jdbc connection (oracle.jdbc.driver.OracleDriver) using a tcpip connection to oracle (jdbc:oracle:thin:@serverip:1521:sidname) - we have tried to use the 'classes12.zip' file supplied with 8i, and have also tried the 'ojbdc14.jar' for 9i with little difference in results.

Has anyone seen this kind of problem, and do you have any thoughts on how to fix it? Received on Tue Oct 21 2003 - 21:13:10 CDT