Re: [suse-oracle] Oracle Automatic Memory Management (AMM) on Suse
Arturo Gutierrez <[email protected]> Tue, 12 Feb 2013 22:22:48 +0100
| Newsgroups | gmane.linux.suse.oracle.general |
|---|---|
| Message-ID | <[email protected]> |
Thanks for the reply. However with this setting seems like memory is limited to 7.9 GB. Filesystem Size Used Avail Use% Mounted on udev 7.9G 2.4M 7.9G 1% /dev tmpfs 7.9G 7.3G 567M 93% /dev/shm /dev/sda1 198M 142M 46M 76% /boot I can't understand how the Oracle instance start with the setting = MEMORY_TARGET=3D12G Version info. USE Linux Enterprise Server 11 (x86_64) VERSION =3D 11 PATCHLEVEL =3D 1 Thanks Arturo Arun Singh wrote: > Hello Arturo, > > You have to adjust /dev/shm, if you are increasing SGA/PGA size with new = RAM (16 -> 64), as Oracle DB is main consumer here. > > Hope this helps, > Arun > > = >>>> On 2/12/2013 at 10:16 AM, Arturo Gutierrez >>>> = > <[email protected]> wrote: > = >> Hello everyone, >> >> I have a question about the automatic memory management introduced in = >> Oracle11g R1 called AMM. >> >> As you know with this memory management is defined by parameter = >> MEMORY_TARGET the amounts of memory allocated to SGA / PGA globally, and = >> MMAN (Memory Manager) memory transfers from one area to another = >> dynamically depending on the workload. In what is so far working on Red = >> Hat. Had to define a suitable size in the virtual memory system (tmpfs). >> example: >> tmpfs / dev / shm tmpfs size =3D 1200m 0 0 >> To avoid errors like: >> SQL> startup >> ORA-00845: MEMORY_TARGET not supported on This System >> >> I observed a Suse system where you are managing a RAC system with a 12GB = >> MEMORY_TARGET settings and the server has 16GB of RAM. >> Normally the size of / dev / shm is half of RAM. So you have to resize = >> it in / etc / fstab. >> However, in this system is not defined superior value and the instance = >> is enabled with this configuration. >> I wanted to know if this memory management Suse uses another mechanism? >> And that must be taken into account for a RAM upgrade, as this thinking = >> go from 16GB to 64GB. >> >> Many Thanks >> Arturo >> >> -- = >> >> >> >> >> Arturo Guti=E9rrez G=F3mez >> >> >> Formador/Consultor Tecnologias Oracle >> >> = >> >> Oracle DBA Certified Professional OCP [7.3-11g] >> Oracle Real Application Clusters Certified professional >> >> Oracle Linux Certified professional >> >> >> = >> >> >> Mov=EDl 61 64 70 190 >> >> >> = >> >> * * >> >> * * >> >> * * >> >> / / >> >> _______________________________________________ >> suse-oracle mailing list >> [email protected] = >> http://listx.novell.com/mailman/listinfo/suse-oracle >> = > _______________________________________________ > suse-oracle mailing list > [email protected] > http://listx.novell.com/mailman/listinfo/suse-oracle > = -- = Arturo Guti=E9rrez G=F3mez Formador/Consultor Tecnologias Oracle = Oracle DBA Certified Professional OCP [7.3-11g] Oracle Real Application Clusters Certified professional Oracle Linux Certified professional = Mov=EDl 61 64 70 190 = * * * * * * / / _______________________________________________ suse-oracle mailing list [email protected] http://listx.novell.com/mailman/listinfo/suse-oracle