To help us decide whether to install a 32bit or 64bit flavour of Oracle, I need to find out the advantages and disadvantages of the two choices. Yes, I do know that the 32bit option restricts us to less than 4GB per process. Yes, I do know that utilizing more than 4GB on a 32bit OS is tricky, but that part is handled by the OS very well these days (being it Linux or Windows).
My question is more on the topic: Will the memory demand of a 64bit OS (including the 64bit flavour of Oracle) require more physical memory than the 32bit counterpart does? And if so, how much overhead will there be? Reason for asking is that we do not have unlimited physical memory available.
Does it make a difference if we use a 32bit version under Linux or Windows (I assume under 64bit it does not)? My gut feel is that Oracle on windows is not as good as on Linux in handling memory sizes > 4gb in its 32bit flavour. Am I right?