Database Tuning (MOSC)

MOSC Banner

setting up auto SGA

edited Dec 13, 2010 8:09AM in Database Tuning (MOSC) 6 commentsAnswered
 I understand the steps to setup auto SGA. Right now, the database I have does not have spfile setup. If I modify the init.ora, to set up sga_target and sga_max_size and then comment out some parameter. That will require me to bounce the database. If I then create the spfile after the parameter modification, that will require me to bounce the database again in order for the spfile to take effect. My question is , can I create the spfile first and bounce just once for the file to take effect and then dynamically set up the sga_target and sga_max_size

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center