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

From: Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl>
Date: Mon, 22 Sep 2003 19:12:55 +0200
Message-ID: <i8bumvsjbpvusdnrs2pueu92be4lq7cq1p@4ax.com>

On Mon, 22 Sep 2003 18:53:41 +0200, "Marco Vannini" <m.vannini_at_tinCANCELLA.it> wrote:

>
>"Sybrand Bakker" <gooiditweg_at_sybrandb.nospam.demon.nl> ha scritto nel
>messaggio news:i29umvgbria803j0n5nnmnnvbtk4433bgs_at_4ax.com...
>> On 22 Sep 2003 09:11:16 -0700, tom_at_siliconbunny.com (Tom Kranz) wrote:
>>
>> >Does anyone have any ideas?
>>
>> Don't be so silly tio run 32-bit Oracle on 64 bit server
>>
>Why? This shouldn't impact the performance, only limiting SGA size. Someone
>asserts that 32-bit executables are a bit faster (I don't know, I'm running
>64-bit oracle on Solaris...)

Because if your O/S has a 64 bit wordsize 32-bit integers are 'special' datatypes, which need to be emulated or converted. Contrary to your unnamed 'someone' we found the opposite. However in this case some moron did reprogram an eprom so the 64-bit server would run 32-bit apps only.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Sep 22 2003 - 12:12:55 CDT