1) The SHMMAX should be larger than the largest SGA and a maximum of 1/2 of physical RAM.
If we are using Automatic Memory Management (AMM) then it may be possible that the SGA will grow.
What is the best way to address this when sizing SHMMAX?
Follow the Oracle Doc, that is best possible I can say.
- Pavan Kumar N
I've seen Oracle recommendations for SHMMAX as follows:
- 1/2 Physical RAM at Maximum
- Larger than the largest SGA (so SGA fits in one shared memory segment)
Which one are you referring too?
Why is that your recommendation?