Networks

Ask something
Question Locked

64 bit vs 32 bit

0 helpful
8 replies

by naughtymonkey

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am getting ready to build a development server for one of our applications to host oracle for a client. The customer data set is huge and will take at least a month to load with large updates monthly after the initial data set. Our application is 32 bit but runs fine on 64 bit Windows. I am trying to figure out if we will see a performance gain by running on 64 bit Windows with 32 bit Oracle or 64 bit Oracle and Windows. If anyone has any real world comparisons, please let me know.

8 replies

by luc_andre

I don't have any experience on those platforms but from what I know unless the application is written in 64-bit it won't give any performance gains in 64-bit windows. It may actually be slower.

by sgt_shultz

plus i think it would depend on exactly what performance issues you have or are anticipating...

by marv732

I'm assuming huge means 1TB + so I wouldn't even contemplate a 32bit Oracle instance for that.

Where you keep the application is really not relevant as it will obviously run fine on either platform although you don't mention whether it is intended for clients to run or it needs to run on the server.

Providing you have someone who is a competent Oracle DBA design the system (tablespace layout, IO, disk, RAM etc) you should get much better performance in the situation you describe (data warehouse?) on 64bit.
Preferably you should also use the current version of Oracle (10.2.0.x) and consider tuning for VLDB if the dataset really is huge and growing.

I suggest that if the above does not apply then you should start some serious reading at
http://www.oracle.com/technology (Oracle Tech Net) to learn all you can ASAP.

You should also consider Oracle RAC (Real Application Clusters) if performance is likely to be an issue.

HTH
Greg

by naughtymonkey

I can just make a recommendations on what I can find for this type of situation. Posts on the Oracle boards leaned toward it would still be better. After installed, it ran like crap. Don't know if it is something they did since it ran great when I passed it off to the DBAs, but I ended up doing 32 bit for everything.

by cg it

I think the questioner doesn't realize that 64 bit processors are backward compatible with 32 bit compiled programs so that his 32 bit compiled program will run.

It's not a 32 bit compiled program running in 64 bit word. The processor can not read 32 bit word compiled code in 64 bit word.

by naughtymonkey

It is if it will run better, the same, or worse. If Oracle is 64 bit, but the app using it is 32, will I see the performance gains that come with 64 bit processing, or will the 32 bit app be a bottleneck?

by r.shankarbabu

I think the below link would provide you with the answer to your question

http://www.microsoft-oracle.com/assets/pdf/oracle_performance_em64t_6850.pdf

Hope that helps.

This discussion is closed to new replies.