How to increase 32 bit Oracle memory usage in 11g
Oracle 11g is installed on a server that has 4GB of RAM but Oracle is only using 1GB. How do I increase this?
There is a setting in the initialization file used by Oracle that controls the amount of memory that is allocated to the Oracle instance. The name of the setting used is "MEMORY_TARGET". To change this setting do the following.
1. browse to the [Drive]:\Oracle\admin\RproODS\pfile folder and open the init.ora file. Locate the line in that file that reads
"memory_target= " and change the value to an appropriate amount. In the case of a Windows Server that has 3GB or more of addressable memory you could change this to 2 GB.
Save the file and then restart the RProods service to apply the changes.
Notes and Recommendations:
Prior to making any changes to the init.ora it is recommended that you make a backup copy of the file first.
Before making changes to the Memory Target variable take into consideration other (non RPRO related) memory requirements of the host system.
If you are using a 32 bit operating system make sure the host system can address memory above 2GB. For details on this topic consult the Microsoft support site.
For information on how to optimize memory use on 64bit systems please review the following article.