I think setting SHMMAX to 75% of available memory is a little conservative. I like to set the SHMMAX to the size of the available memory (although I wouldn't actually make the SGA this big). This will give you the flexibility to increase the size of the SGA when you need to, without having to rebuild the kernel and reboot the UNIX machine.
Dig Deeper on Oracle and SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.