Is there a limit to how high memory_max_target can be set?
1012218May 31 2013 — edited May 31 2013We are running Oracle 11g R2 64-bit on a server with Windows Server 2008 R2 Enterprise 64-bit. The machine has 64GB of RAM and there are four databases setup.
When trying to allocate the RAM for the four databases, we set the memory_max_target and memory_target as follows:
DB1 = 8GB
DB2 = 32GB
DB3 = 4GB
DB4 = 8GB
This leaves 12GB for the OS.
This all worked fine and is set correctly in the databases, but when looking at the task manager, the oracle.exe processes show the memory being used as we set it for three if the four. The one database set to 32GB is only using 16GB for some reason. Do any of you know why this is? Is there a maximum limit that can be allocated to the database?
Edited by: 1009215 on May 31, 2013 7:49 PM