CentOS - Aug 2007 - same Old question: 32 bits VS 64 bits on database performance

We have several large projects will use ORACLE 10Gr2
database with CENTOS 4.X.  Does anyone have
performance report on 32 Bits O.S. (with 32 bit
ORACLE) VS 64 bits?

Thanks.


     
____________________________________________________________________________________
????????????? - ???? Yahoo!??????http://tw.info.yahoo.com/seal/index.html

On Monday 27 August 2007, mcclnx mcc wrote:
> We have several large projects will use ORACLE 10Gr2
> database with CENTOS 4.X.  Does anyone have
> performance report on 32 Bits O.S. (with 32 bit
> ORACLE) VS 64 bits?
>
> Thanks.
Don't have anything recent on 10g and 4.x but we did some testing with a 
pre-release version of 11g running on CentOS 5... We started with 2GB ram on 
a Core 2 Duo E6400. 

The results with our tests and data sets showed that the difference is nothing 
you will notice. In most cases the 64bit version was a tiny bit slower. 
However, two results were unusual. When processing outer left joins, the 
64bit version was quite a bit faster - somewhere around 15%. The opposite was 
true on rollback of large transactions resulting from deadlocks. There the 
32bit version was much subjectively faster. No exact timings though since I 
have no idea how to measure the exact time of a deadlock detection :) 

Once you add more ram though or go to a larger smp system, the 64bit quickly 
leaves behind the 32bit version... All that said, we decided to go 64bit only 
for what we do here, even of small dev boxes. That makes the environment 
consistent and nothing we saw showed there was any real advantage to staying 
32bit is your hardware supports 64. 

Also, you will find other benchmarks online. There are some that show a large 
benefit of using 64bit (usually large memory systems) and others that show a 
benefit of staying 32bit (usually systems with small amounts of memory). Yet 
others show results similar to what we found. In the end it comes down to how 
much ram you have, your index types and some other things. If you need to 
know a good result for your scenario, you will have to do the testing 
yourself.

Peter.

> We have several large projects will use ORACLE 10Gr2
> database with CENTOS 4.X.  Does anyone have
> performance report on 32 Bits O.S. (with 32 bit
> ORACLE) VS 64 bits?
I don't have any "report" per se, however, I have production  
experience with Oracle 9i, 9iR2, 10g, and 10gR2 on RedHat 7.3, CentOS  
3.X, and CentOS 4.X (32 and 64-bit).  Typically speaking, there isn't  
a huge increase in performance moving from 32-bit to 64-bit (Dell  
PowerEdge 2950).  I'd guess it's around 5-10% on the same hardware.   
However, the scalability of 64-bit - especially with regards to memory  
usage - should make this a no-brainer.  ALWAYS go with 64-bit where  
possible for databases and application servers.

If you are trying to same money and stick to older 32-bit hardware,  
there are of course workarounds for the memory limitations of the  
32-bit OS using "hugepages".
See the following:
http://www.puschitz.com/TuningLinuxForOracle.shtml#LargeMemoryOptimization

-Ken