Is it possible to control the virtual memory size of ORACL.EXE (win2003)?
510293Oct 4 2007 — edited Oct 10 2007Hi, all.
Our database is on 32 bit Windows 2003 EE SP1.
Recently, I found out that the virtual memory size for oracle.exe is larger than
physical memory size that was allocate to oracle.exe.
Total physical memory is 8Giga.
According to the Task Manager, about 700M physical memory is allocated to
oracle.exe, but 1200 M virtual memory is allocatd to oracle.exe.
My questions are :
1. Is it possible to control the size of virtual memory that is allocated to oracle.exe by using Windows option or adding/modifying registry key or
something else??
--> Resizing SGA is not an option.
--> Adding more physical memory is not an option
2. Is "LOCK_SGA" parameter working on 32bit windows 2003 EE SP1??
The database version is 10.2.0.2.0.
Thanks and Regards.