Even though, upto 10GB of RAM is available to be utilised, default settings on windows do not allow the Oracle Database to acquire more than 2GB (irrespective of the Physical Address space defined). To allow the Oracle Database instance to acquire more than 3GB, we have to turn on the /3gb switch on the Operating System.
In Windows 2003 Server
In Windows 2003 Server (Enterprise Edition), the 3GB switch can be turned ON using the boot.ini file
Note: The boot.ini file is available in the default drive (C:). You might have to show hidden and system files to view and edit the file.
Open the boot.ini file and locate Operating System parameters.
- At the end of the parameter list, Add /3gb
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Microsoft Windows XP Professional" /fastdetect /usepmtimer /NoExecute=OptOut /3gb - Save the boot.ini file
- Restart the Server for the changes to take effect
For more about the /3gb switch on Windows 2003 Server, read this
On Windows 2008 Server
On the Windows 2008 Server (or Vista OS), the 3gb switch can be turned ON/OFF using the Boot Configuration Data Editor (BCDEdit). [Read more about BCD]
To turn ON the 3GB Switch,
- Run the Command Prompt (cmd) as Administrator.
- Type
bcdedit /set IncreaseUserVA 3072
and press Enter - Restart the Server
- Type bcdedit on command prompt to check the current value of IncreaseUserVA
3072 = 3 * 1024 MB = 3GB
To Turn OFF the 3GB switch, type
bcdedit /deletevalue IncreaseUserVA
No comments:
Post a Comment