Dave > What would be the best way to do this in a non-RAC env? All that I > can figure is: > > ALTER SYSTEM RESET db_cache_size SCOPE = memory SID = '<sid>'; > /* Since SCOPE = spfile doesn't work in a non-RAC env as the sid > value isn't * included within the spfile. */ There is no difference between RAC and non-RAC environment. The part about the SID is always available. If nothing is specified, which is common in non-RAC environment, the character "*" is used instead. In a RAC environment the character "*" is used for most parameters as well. In fact you use the SID only for those parameters that must be instance specific. Therefore to remove a parameter for a single instance, or from multiple instances with RAC, you can use the following statement. ALTER SYSTEM RESET <parameter> SCOPE=spfile SID='*' > CREATE pfile FROM spfile; > /* to make sure any other changes get saved in the pfile, since > that'll be * used on next instance startup. */ > > Then remember to delete line 'db_cache_size = ...' from the pfile > before > the next instance bounce, then startup the instance using the pfile. > > CREATE spfile FROM pfile; > /* so that the spfile is now current with pfile changes. */ i.e. it's not reason to do it in this way... HTH Chris -- http://www.freelists.org/webpage/oracle-l