It's 9.2.0.7 on Windows 2003
>From: "Rich Amick" <rAmick_at_dotster.com>
>To: <cemail_219_at_hotmail.com>, <oracle-l_at_freelists.org>
>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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
>On Behalf Of J. Dex
>Sent: Wednesday, August 23, 2006 10:05 AM
>To: oracle-l_at_freelists.org
>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
>
>--
>http://www.freelists.org/webpage/oracle-l
>
>
Get real-time traffic reports with Windows Live Local Search
http://local.live.com/default.aspx?v=2&cp=42.336065~-109.392273&style=r&lvl=4&scene=3712634&trfc=1
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 23 2006 - 12:14:47 CDT
