Re: Changing DB_CACHE_SIZE to DB_BLOCK_BUFFERS

From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
Date: Wed, 23 Aug 2006 18:26:41 +0100


If you want to play safe, a better strategy might be:

   create pfile from spfile;

Then copy and edit the pfile (init.ora file) to make
all the changes you need, rename the spfile, and
restart the database.


Regards

Jonathan Lewis
http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

----- Original Message ----- From: "J. Dex" <cemail_219@xxxxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Wednesday, August 23, 2006 6:05 PM 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=wlmailtagline
--
//www.freelists.org/webpage/oracle-l


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

References:
- Changing DB_CACHE_SIZE to DB_BLOCK_BUFFERS
  - From: J. Dex

Re: Changing DB_CACHE_SIZE to DB_BLOCK_BUFFERS

Other related posts: