Total Memory allocation
we are running 9i database on windows 2k. the server has 4gb memory on it. When i allocate anything more than 2GB as total memory to oralce, i am getting error as insufficient memory.
a) Is this because the OS cannot allocate more than 2GB? (i read somewhere that windows by default wont allocate more than 2GB!)
b) can we allocate more than 2GB to daatbase if the server gets another 4GB memory?
search for extended memory for windows
On windows the problem is not exactly how big the SGA can be but how big the process memory can be. The maximum value is only limited by how much address space you have in your Oracle process, and how much memory you have in the machine. You can go upto 3 GB (refer to Microsoft Article ID:Q171793), but due address space fragmentation, it is often not possible to push the envelope on address space usage, so if you try to allocate a huge SGA, you may get failures even if you have enough memory
The SGA value is limited by how much address space you have in your Oracle process, and how much memory you have in the machine. Prior to NT4.0 SP3, you were limited to 2GB of address space per process so physical memory exceeding 2GB would not benefit Oracle. However, now
Oracle can address up to 3GB on Windows 2000 ADVANCED Server and Windows NT 4.0 Enterprise Edition as long as the /3GB switch is set in the boot.ini file. As a general rule, we do not recommend you allocate more than 50% of your available memory for the SGA.
Click Here to Expand Forum to Full Width