| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Changing DB_CACHE_SIZE to DB_BLOCK_BUFFERS
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
"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_at_trivadis.com]
> Sent: Sunday, September 03, 2006 2:33 PM
> To: Herring Dave - dherri
> Cc: oracle-l_at_freelists.org
> 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
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Sep 03 2006 - 16:09:37 CDT
 |
 |