Ask the Expert

Can I resize SGA while the database is up and running?

Can I resize SGA while the database is up and running?

    Requires Free Membership to View

Yes and no. It depends on your setting for SGA_MAX_SIZE. If you have not set this parameter, it defaults to your total SGA size. In this case, you cannot increase your SGA size while the instance is running but you can decrease the SGA size. If you want to increase your SGA size while the instance is running, you will need to have previously set the SGA_MAX_SIZE parameter to allow for this growth.

This was first published in March 2008

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: