Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Difference between Oracle 32-bit and Oracle 64-bit

SOLVED
Go to solution

Difference between Oracle 32-bit and Oracle 64-bit

Hi All,
We are moving to Oracle 9.2 and I want to recommend to install 64-bit instead of 32-bit which we were using before. Ofcourse the question arises, what is the difference between Oracle 32-bit and Oracle 64-bit. We have HP-UX 11i 64 bit installed.
7 REPLIES
Jeff Schussele
Honored Contributor
Solution

Re: Difference between Oracle 32-bit and Oracle 64-bit

Hi Sushil,

Major difference would be more than a terabyte of addressable memory.
32-bit applications can only address 1.75Gb of memory - whereas 64 bit apps can address up into the Terabyte range.

Rgds,
Jeff
PERSEVERANCE -- Remember, whatever does not kill you only makes you stronger!
A. Clay Stephenson
Acclaimed Contributor

Re: Difference between Oracle 32-bit and Oracle 64-bit

If you have the option, 64-bit Oracle is the way to go. The biggest difference is that SGA's can now be huge -- many GB's --- and 9i really needs large SGA's to perform well. Of course, if your box only has 1GB of memory then you might as well stay in 32-bit land. A common misconception is that 64-bit code executes faster; it doesn't. You should really think of it as a resource enhancer rather than a performance booster. However, because caches and other data structures can be much larger in 64-bit land then the overall performance can increase dramitically over its 32-bit counterpart.
If it ain't broke, I can fix that.
Michael Steele_2
Honored Contributor

Re: Difference between Oracle 32-bit and Oracle 64-bit

Oracle will preloads its SGA with large objects, or, provide a means for loading very large objects. This caching scheme is for better performance.

32 bit has memory limitations that make this large object pre-loading more difficult.

64 bit also allows for much larger shared memory which newer versions of oracle rely upon.
Support Fatherhood - Stop Family Law

Re: Difference between Oracle 32-bit and Oracle 64-bit

Thank you guys,
I think now I have something to make my case for 64-bit Oracle.

Thanks
Sushil Singh
Steven E. Protter
Exalted Contributor

Re: Difference between Oracle 32-bit and Oracle 64-bit

There is a procedure you MUST run on the data to convert word size from 32 bit to 64 bit.


Attaching it.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Jean-Luc Oudart
Honored Contributor

Re: Difference between Oracle 32-bit and Oracle 64-bit

As far as I know Oracle9i on HPUX is 64bits.
Nevertheless, the client software can be either 32 or 64 bits. You just have to choose the right PATH for the libclntsh.sl



http://forums1.itrc.hp.com/service/forums/parseCurl.do?CURL=%2Fcm%2FQuestionAnswer%2F1%2C%2C0xc835349f786acc4ab21d36da9d59a127%2C00.html&admit=716493758+1066231747046+28353475

Rgds,
Jean-Luc
fiat lux
Yogeeraj_1
Honored Contributor

Re: Difference between Oracle 32-bit and Oracle 64-bit

hi,
-
I would simply add:
A 64bit OS would allow us to address much more memory then a 32bit one. On a 32bit system (a system where pointers are 32bits) we can address 4gig or less of RAM. That limits the size of an SGA. On a 64bit system -- we can address an incredibly large SGA.
-
hth
Yogeeraj

No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)