MEMORY_MAX_TARGET recommendations. Automatic memory management AMM

Posted on 2012-08-14
Medium Priority
Last Modified: 2012-08-22
I am looking at increasing the memory in our databases.
select name, value, display_value from v$parameter
where name like '%sga%'
select name, value, display_value from v$parameter
where name like '%memory%';

Open in new window

I want to go to automatic memory management and increase the memory_max_target to 6G.     Inorder to do this I need to increase the tmpfs to greater then 6G. The default is 50% of memory.
tmpfs                   /dev/shm                tmpfs   defaults        0 0

I read I can do the following.
To adjust the shared memory file system size issue the following commands, specifying the required size of shared memory.

# umount tmpfs
# mount -t tmpfs shmfs -o size=6144m /dev/shm
Make the setting permanent by amending the "tmpfs" setting of the "/etc/fstab" file to look like this.

tmpfs                   /dev/shm                tmpfs   size=6144m      0 0

[root@x ~]# df ls -la /dev/shm
df: `ls': No such file or directory
Filesystem           1K-blocks      Used Available Use% Mounted on
tmpfs                  4194304   2208512   1985792  53% /dev/shm
[root@reptstdwhdb01 ~]# df ls -h /dev/shm
df: `ls': No such file or directory
Filesystem            Size  Used Avail Use% Mounted on
tmpfs                 4.0G  2.2G  1.9G  53% /dev/shm
[root@x ~]# 

Open in new window

My questions are is there any standards for setting automatic memory.
I know I have 8G memory I want to assign 6G to memory_max_target
I know if I don't assign more then 6G to tmpfs I will get an error.
I read on http://johnpjeffries.wordpress.com/tag/shmfs/
that the tmpfs should be 20% more then memory_max_target.

I could drop memory_max_target to 5G approx or increase tmpfs to approx 7G.  I need some guidance. Thanks in advance.
Question by:dplinnane
1 Comment
LVL 78

Accepted Solution

slightwv (䄆 Netminder) earned 2000 total points
ID: 38291615
>>My questions are is there any standards for setting automatic memory.

No real standards that I know of.  You just never want to swap memory to disk.  As long as 2 Gig will support all the server processes you will ever have then 6 Gig should be fine.

>>df ls -la /dev/shm

df and ls are stand-alone commands.

Instead of a Blog I would suggest the installation guide from oracle.

Oracle® Database Installation Guide
 11g Release 2 (11.2) for Linux


Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.
Suggested Courses
Course of the Month15 days, 10 hours left to enroll

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question