Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Changing DB_CACHE_SIZE to DB_BLOCK_BUFFERS
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
> 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
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 23 2006 - 12:26:41 CDT