Changing DB_CACHE_SIZE to DB_BLOCK_BUFFERS

  • From: "J. Dex" <cemail_219@xxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 23 Aug 2006 13:05:15 -0400

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=wlmailtagline

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


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 08-2006