Re: Oracle performance problem

What are the specs for the servers in term of CPU/RAM and also is the storage still the same?

I would recommend running 64-bit 8.1.7 on Solaris, but I do not think this is your problem, unless these are large memory boxes. With 32-bit Oracle, your SGA is limited around 4gb if I remember correctly.

We run 32-bit Oracle (8.1.7.4) on Solaris 8 64-bit and have no problems. Oh yea, I would patch to 8.1.7.4 as well.

Hope this helps,
CC

Mike Wombat wrote:
> I have a puzzling performance problem. When an Oracle 8.1.7 database
> was moved from an SGI Origin 2000 server to a SUN E4500 server, the
> users noticed a significant degradation in the performance. One of
> the possible factors we are considering to address this performance
> problem is that we run 32-bit version of Oracle on 64 bit Solaris 8 on
> a SUN box whereas a 64 bit Oracle runs on 64 bit IRIX 6.5.3 on the
> Origin 2000. The SGAs for the database are almost the same on both
> machines.
>
> My question is whether running 32-bit Oracle on 64 bit Solaris 8 can
> have a significant impact on the performance as compared with the same
> database instance (but 64 bit) running on 64 bit IRIX 6.5.3.
>
> Thanks for any hints.

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Fri Nov 08 2002 - 09:23:46 CST