From: "Rich Amick" <rAmick@xxxxxxxxxxx>
To: <cemail_219@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
Subject: RE: Changing DB_CACHE_SIZE to DB_BLOCK_BUFFERS
Date: Wed, 23 Aug 2006 10:12:21 -0700
Depends upon what version of Oracle and what OS.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of J. Dex
Sent: Wednesday, August 23, 2006 10:05 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Changing DB_CACHE_SIZE to DB_BLOCK_BUFFERS
After creation, can a database that was created using DB_CACHE_SIZE be
changed to use DB_BLOCK_BUFFERS? We want to use AWE extended memory so I
need to use DB_BLOCK_BUFFERS. Is this the correct way to make the changes?
startup nomount
ALTER SYSTEM SET USE_INDIRECT_DATA_BUFFERS=TRUE scope=spfile;
ALTER SYSTEM SET DB_CACHE_SIZE = 0 scope=spfile;
ALTER SYSTEM SET DB_BLOCK_BUFFERS = 524288 scope=spfile;
_________________________________________________________________
Call friends with PC-to-PC calling -- FREE
http://imagine-msn.com/messenger/launch80/default.aspx?locale=en-us&source=w
lmailtagline
--
//www.freelists.org/webpage/oracle-l
