Tunning

[rashid.farouq]

Hi,
I need help to tune production database, currently havingOracle EBS RAC enabled using SAN over ASM and LB the RAM of each database node 64G there are two RAC db Node and 2 apps node having concurrent users 500+, currently sga_max_size=12G and pga_aggregate_target= 2060M, please advice ether should I go for AMM or ASM and at is recommendation for  sga and pga for manual or what should max_target for auto.

Thanks

[ErmanArslansOracleBlog]

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..

[rashid.farouq]

Thanks Erman for prompt response, actually there was typo mistake, I mean to have advice on Automatic Memory Management (AMM) or Automatic Shared Memory Management (ASMM), so seeking your advice to set sga_max_target an pga_aggregate and need help to configure hugepages according to mentioned scenario.

[ErmanArslansOracleBlog]

Okay. increase SGA and PGA if you can.
Use ASMM and configure hugepages.. This is my advice.

[Farouq]

Dear Erman,

I trying to size memory parameters please advice.

Total RAM=64G

SGA = 64GX70%=44.8G (70% of Total Mem)  
PGA 44.8GX20%=8.96G (20% of Total SGA)

[ErmanArslansOracleBlog]

This seems okay.. But monitor it.. Ensure you are not running out of memory.. Not going to swap..

Configure hugepages as well.
Configure hugepages to store your SGA segments.

[Farouq]

Daer Erman

Thanks for valuable advice, will set the memory params and get back to you if there is any problem.

Rashid