Re: Tunning

Posted by ErmanArslansOracleBlog on Jan 01, 2018; 12:03pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Tunning-tp4789p4790.html

AMM and ASM is 2 completely different things.

AMM is automatic memory management.
ASM is Automatic Storage management.

(Extra info : ASMM is automatic shared memory management..)

So one is related with storage , other one is related with memory.

As for the storage, what I recommend for you is to use ASM or ACFS.. (on top of SAN disks)
As for the memory, I recommend you to increase your SGA and pga_aggreaget_target (if you have RAM ofcourse), configure hugepages accordingly and use "ASMM" (automatic shared memory management) not AMM..

Read the defitinion of ASM, ASMM and AMM , then you will understand what I m saying..