I went through those hoops below because I incorrectly thought I had to provide the sid value (never thought to try asterisk): alter system reset sort_area_size scope = spfile sid = '...' * ERROR at line 1: ORA-32010: cannot find entry to delete in SPFILE Not sure what I'm missing, but at least I now know '*' works and will definitely share that info!! Thanks Chris! Dave ------------------------------------- Dave Herring, DBA Acxiom Corporation 3333 Finley Downers Grove, IL 60515 wk: 630.944.4762 <mailto:dherri@xxxxxxxxxx> ------------------------------------- "When I come home from work and see those little noses pressed against the windowpane, then I know I am a success" - Paul Faulkner > -----Original Message----- > From: Christian Antognini [mailto:Christian.Antognini@xxxxxxxxxxxx] > Sent: Sunday, September 03, 2006 2:33 PM > To: Herring Dave - dherri > Cc: oracle-l@xxxxxxxxxxxxx > Subject: RE: Changing DB_CACHE_SIZE to DB_BLOCK_BUFFERS > > 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 ************************************************************************* The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank you. ************************************************************************* -- //www.freelists.org/webpage/oracle-l