RE: Changing DB_CACHE_SIZE to DB_BLOCK

From: Herring Dave - dherri <Dave.Herring_at_acxiom.com>
Date: Sun, 3 Sep 2006 10:00:46 -0500
Message-ID: <7ED53A68952D3B4C9540B4EFA5C76E36022C9D07@CWYMSX04.Corp.Acxiom.net>

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_at_acxiom.com>

"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_at_freelists.org

[mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Christian Antognini
> Sent: Thursday, August 24, 2006 9:12 AM
> To: cemail_219_at_hotmail.com
> Cc: oracle-l_at_freelists.org
> 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
> --
> http://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.

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Sep 03 2006 - 10:00:46 CDT