Re: Poor Oracle performance with Solaris 8 on a Sunfire, talking to a SAN

From: James Williams <willjamu_at_mindspring.com>
Date: Tue, 23 Sep 2003 23:53:13 GMT
Message-ID: <3f70dc0f.1109254@news.east.earthlink.net>

On Mon, 22 Sep 2003 18:34:02 +0200, Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl> wrote:

Solaris 2.8 is 64 bit by default but 32 bit OS is fine as different comands (LSEEK, etc,.) required to exploit 64 bit.

This sounds like are similiar problem that I had last year when installing ARCSDE on Solaris 2.8 on V880's using VXFS. We actually had to rebuild the RAID 0+1 disk arrays because of a back plane problem.

The log file sync time was out of sight. Each commit caused a wait.

After rebuilding the disk array the log file sync time went down to 8 milliseconds. Problem solved!

Run statspack during this interval.

>
>Don't be so silly tio run 32-bit Oracle on 64 bit server
>and next time please don't post meaningless O/S data
>
>
>Sybrand Bakker, Senior Oracle DBA
>
>To reply remove -verwijderdit from my e-mail address
Received on Tue Sep 23 2003 - 18:53:13 CDT