Ask the Expert

Maximum value for SHMMAX

Is there a general rule concerning the maximum value to set SHMMAX to? I heard it should not be set to more than 75% of available RAM. Currently we are running two Oracle databases, have a total of 4 GB bytes of memory and have SHMMAX set to 1 GB byte. We are considering upping that to 3 GB bytes so that one of our databases can have more SGA.

    Requires Free Membership to View

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.

This was first published in July 2002

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: