CJohnRun wrote:Even though the OS can support up to 64GB of RAM the user process space is still under the 32-bit limit.
I don't believe that's entirely true as x86 Windows 2003 Enterprise OS (which is the OS in question) can support up to 64GB of RAM with PAE enabled, but all of my attempts at increasing the SGA/PGA size over 4GB is in vain...
PAE does not change the amount of virtual address space available to a process. Each process running in 32-bit Windows is still limited to a 4 GB virtual address space.Source: http://msdn.microsoft.com/en-us/library/aa366796%28VS.85%29.aspx
Correct, I get that, but back to my question, does this also apply if the OS is 64 bit?
Virtual Address SpaceBy default, 64-bit Microsoft Windows-based applications have a user-mode address space of 8 terabytes>
SGA size Maximum value Operating system-dependent; typically 2 to 4 GB for 32-bit operating systems, and > 4 GB for 64-bit operating systems
Although the ultimate solution will come when Windows supports a 64-Bit virtual address model.is even more misleading as Windows has had x64 Operating Systems out for the better part of a decade.
CJohnRun wrote:Please see the document that I linked to in my original reply. The Standard Edition of 64 bit Windows 2003/2008 Server is artifically limited to 32GB in a flat memory model. The Enterprise Edition of 64 bit Windows 2003/2008 Server supports more memory than you can physically connect to the server's motherboard. 64 bit Oracle Database Standard Edition One and greater is able to take advantage all of the memory in the server that is provided within the flat memory model without any special configuration - other than enabling large page support to decrease the overhead of managing a lot of memory.
I don't believe that's entirely true as x86 Windows 2003 Enterprise OS (which is the OS in question) can support up to 64GB of RAM with PAE enabled, but all of my attempts at increasing the SGA/PGA size over 4GB is in vain as stated in this note (46001.1). Will I run into these same issues with x64 Windows or not? I'm asking because I do not want to rebuild the OS as x64 just to run into the same issues.
CJohnRun wrote:You might also get related information in the doc set (ref tahiti.oracle.com above). The more useful doc is the 'Platform Guide for Windows' which discusses the various limits that the Reference manual says are platform specific.
I appreciate the expanded explanation, but the reason why I kept probing for more answers is that you provided me with a MS link. It looks like the best thing that I'm finding from Oracle is the Certifications tab in Metalink.