Dear all,
I have seen following statement i am getting bit confused.
" /dev/shm must be greater than the sum of MEMORY_MAX_TARGET for all instance on the server"
>> Allocated memory on my personal system for single database.
SQL> show parameter MEMORY_MAX_TARGET;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
memory_max_target big integer 872M
SQL> show parameter MEMORY_TARGET;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
memory_target big integer 872M
>> My current configuration of /dev/shm on my machine
tmpfs | tmpfs | 1.2G 596M 547M 53% /dev/shm |
>> Allocated memory on my personal system for single database.
Right now i have only 1 database on my machine.
if i have '10' databases on my machine,
should i allocate value of /dev/shm is greater than, sum of all instances (10) memory_max_target value ?
>> Is this correct ?
value of /dev/shm > memory_max_target * 10 (all instances )
OS : Oracle Linux 5.6
DB : 11.2.0.2