Re: jdbc performance in Solaris

We have had a lot of problems with our Windows database servers running circles around our Solaris ones.

I've found two init parameters that help in our situations. Maybe you could try them. We have 9.2.0.5 Oracle on Solaris 8.

dbwr_io_slaves=4
filesystemio_options=setall

• Bobby

Joe Smith wrote:
> 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 - 08:45:10 CST