Originally Posted by syedkaleem
I have been ordered to transfer my database running on oracle 10g on linux 32 bit OS to linux 64 bit.
Are you changing just the Linux OS from 32 bit to 64 bit, or also changing the Oracle database software from 32 bit to 64 bit?
I don't know anything about the Oracle software, most importantly I don't know whether there is a 64 bit version available and I don't know whether the installer for the 32 bit version will tolerate a 64-bit Linux. (I would wild guess that both are true: there is a 64-bit version and the 32-bit version will also install on a 64-bit Linux. But I'm just guessing.)
I need to know the advantages of 64 bit over 32 bit.
A 64-bit OS will probably do a much better job running a 32-bit application, especially a database application, than a 32-bit OS would.
A 32-bit application gets a 4GB virtual address space on a 64-bit OS compared to a 3GB virtual address space on a 32-bit OS. If you have a lot of physical ram, the 64-bit OS can also be more flexible in use of shared regions (which are important to some database applications).
Installing a 32-bit application on a 64-bit Linux might be significantly harder than installing it on a 32-bit Linux, especially for Debian based Linux distributions (less of a problem for RedHat based). But once properly installed, a 32-bit application should run fine on a 64-bit OS, in many cases (likely for database) the 32-bit application will run better on a 64-bit OS than on a 32-bit OS.
Of course, the bigger difference between a 32-bit OS and 64-bit OS is that the 64-bit OS can
run 64-bit applications.
You may intend switching to 64-bit Oracle software at the same time you switch to 64-bit Linux.
In general, 64-bit software could run faster or slower than the 32-bit version of the same software.
Typically, 64-bit software uses the same file formats as the 32-bit version of the same software. But there are exceptions: programs that need all their data files converted if you switch from 32-bit to 64-bit software.
If you intend to switch from 32-bit Oracle to 64-bit Oracle, you can't use "in general" or "typically". You need to know what happens with the specific product you are using. If you are just switching the OS and not the Oracle software, the issues are much simpler and more predictable.