RE: Changing DB_CACHE_SIZE to DB_BLOCK_BUFFERS
- From: "Herring Dave - dherri" <Dave.Herring@xxxxxxxxxx>
- To: <Christian.Antognini@xxxxxxxxxxxx>, <cemail_219@xxxxxxxxxxx>
- Date: Sun, 3 Sep 2006 10:00:46 -0500
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. */
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. */
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: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
> On Behalf Of Christian Antognini
> Sent: Thursday, August 24, 2006 9:12 AM
> To: cemail_219@xxxxxxxxxxx
> Cc: oracle-l@xxxxxxxxxxxxx
> Subject: RE: Changing DB_CACHE_SIZE to DB_BLOCK_BUFFERS
>
> Hi
>
> > >ALTER SYSTEM SET DB_CACHE_SIZE = 0 scope=spfile;
>
> IMHO it is always better to remove the parameters and not to set them
to
> other values that should/can disable a feature... i.e. in such
situation
> I would use ALTER SYSTEM RESET.
>
>
> HTH
> Chris
> --
> //www.freelists.org/webpage/oracle-l
***************************************************************************
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
Other related posts:
