RE: Changing DB_CACHE_SIZE to DB_BLOCK_BUFFERS
- To: "Herring Dave - dherri" <Dave.Herring@xxxxxxxxxx>
- Date: Sun, 3 Sep 2006 21:33:01 +0200
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
