windows 32位的 Oracle 記憶體限制問題

整理了一下,收藏[@more@]windows 32位的問題

遍地都說 3G開關，開了3G開關能給oracle.exe程式的記憶體也就最多3GB嗎？

另外在微軟網站找到這一段：

Physical Address Extension. PAE is an Intel-provided memory address extension that enables support of up to 64 GB of physical memory for applications running on most 32-bit (IA-32) Intel Pentium Pro and later platforms. Support for PAE is provided under Windows 2000 and 32-bit versions of Windows XP and Windows Server 2003. 64-bit versions of Windows do not support PAE.

PAE allows the most recent IA-32 processors to expand the number of bits that can be used to address physical memory from 32 bits to 36 bits through support in the host operating system for applications using the Address Windowing Extensions (AWE) application programming interface (API). More information about the AWE API can be found at the MSDN Library.


透過PAE能支援的記憶體更大的記憶體，但是看過Note:225349.1又發現白高興了，多出來的記憶體只能用作block buffer cache還得用DB_block_buffers指定(除非不用10g的自動sga管理)

程式碼:


What the PAE switch allows you to do from the Oracle perspective is to 

    increase the amount of memory that can be used for the Oracle Database 

    Block Buffer Cache.  It is important to note that this additional memory 

    can ONLY be used by Oracle in the form of an increased value for 

    DB_BLOCK_BUFFERS.