Re: Oracle 8 ( 32 bit vs 64 bit)

"paddy_nyr" <mpprpp_at_yahoo.com> wrote in message news:<c2raf2$20dm29$1_at_ID-197123.news.uni-berlin.de>...
> Can anyone explain to me the benfit performance from moving from Oracle
> 8.1.7.4 32 bit to Oracle 8.1.7.4 64 bit on Solaris 8?
>
> I'm currently have an E450, 4 Gig of memory, 4 x 450 MHZ CPU running and I'm
> thinking of moving to a
> Sunfire V880, 18 Gig of memory, 8 x 1.05 GHZ CPU and should I got to the 64
> bit so I can take advantage of the additional memory?

Depends. Have you googled this group to see previous postings? There is some thought that certain apps run slightly faster in 32 bit because it doesn't have to deal with larger pieces of stuff that 64 implies.

http://www.sun.com/sun-on-net/itworld/UIR951101perf.html

>
> If I stay with the 32bit I can I take advantage of the additional memory
> since 32 bit can only use upto 3.5 Gig (or something like that)

Whether you want to is up for debate. Such a large SGA would have it's own performance issues - think of what happens during a checkpoint. Also see metalink for additional information on the 3.75 G SGA and 32 v 64.

> ?
> Thanks for all feedack.

jg

--
@home.com is bogus.
Taiwan company rips off real site for ad revenues:
http://www.carorcar.com/