Skip to Main Content

Infrastructure Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

/dev/shm Vs MAX_MEMORY_TARGET

JhilOct 1 2016 — edited Oct 1 2016

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

This post has been answered by Dude! on Oct 1 2016
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 29 2016
Added on Oct 1 2016
1 comment
2,622 views