By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.