How to increase 32 bit Oracle memory usage in 11g

Problem:

Oracle 11g is installed on a server that has 4GB of RAM but Oracle is only using 1GB. How do I increase this?

Solution:

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. 
EG;
memory_target=2048M
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.
http://technet.microsoft.com/en-us/library/bb124810(EXCHG.65).aspx

Additional:

For information on how to optimize memory use on 64bit systems please review the following article.
http://partners.retailpro.com/Support/Knowledgebase.php?a=64

Published on Mar 18, 2014 in Installation, Database

 

Find Another Article