Oracle 32bin vs. 64 bit: quick test

What is overhead of using 64 bit addressing on oracle 64 bit systems comparing to 32 bit? For few days, I had test hardware in hands, to do quick check on this.

The quick test is on AMD Dualcore Opteron CPUs (HP BL685) running RHEL 5 and oracle 10.2.0.3

Server config:

4CPU

8GB total memory

2 sas hard drives in hardware mirror

Oracle configuration:

db_block_size 8K

db_cache_size 1200M

shared_pool_size 300M

Dedicated server. All other parameters are defaults.

Load configuration:

For load simulation, swingbench software from Dominic Giles is used (http://www.dominicgiles.com/swingbench.html)

Test: Order Entry application

Customers: 10M

Orders: 250K

Number of concurrent connections: 15 (from 1 client)

DB size: about 4GB

Test Results:

RHEL 5 and oracle 10.2.0.3 32bit

RHEL 5 and oracle 10.2.03 64bit

Conclusion:

AVG Response time

AVG. TPM

32bit

47

6768

64bit

53

6500

For this quick test, it seems that 32bit operations is little faster, this of course what it should be, just to prove on hands.

Note: this test intentions is more for load software familiarization, not academic purposes 🙂 To do more accurate testing required more time and testing, which is not currently available.

2 thoughts on “Oracle 32bin vs. 64 bit: quick test

  1. Thanks for posting.

    If you had the opportunity it may be worth testing on 11G as we are seeing improvements of around 10% on a variety of tests we are running between 10G and 11G (32 bit)

    I will set up the same benchmark today and see what scores we get. Probably post on my blog later on

    John

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s