jdbc performance in Solaris

From: Joe Smith <nospam_at_nospam.com>
Date: Fri, 14 Jan 2005 13:19:05 +0100
Message-ID: <41e7b8b6$0$19424$8fcfb975@news.wanadoo.fr>

Hi,

I have a simple program to perform bulk insertions written in Java.

When using a Windows Oracle 9 base, I get: 330 insertions/second with autocommit on 400 insertions/second with autocommit off

In Solaris (Oracle 9, too), the results are: 44 (!!) insertions/second with autocommit on 430 insertions/second with autocommit off

Both systems are in archivelog mode.

I'd like to know why there's such a difference between windows and solaris, and what could I do (if there's anything) to give me a better performance under solaris.

Could you give me any hints?

I have found a similar problem here:
http://groups-beta.google.com/group/comp.database.oracle/browse_thread/thread/e7922d5bede9ad45/cd125e5cf9ae8241?q=solaris+autocommit&_done=%2Fgroups%3Fq%3Dsolaris+autocommit%26hl%3Den%26lr%3D%26c2coff%3D1%26client%3Dfirefox-a%26rls%3Dorg.mozilla:en-US:official%26sa%3DN%26tab%3Dwg%26&_doneTitle=Back+to+Search&&d#cd125e5cf9ae8241

but it doesn't give any information on how to improve the performance.

Thanks! Received on Fri Jan 14 2005 - 06:19:05 CST