RE: Changing DB_CACHE_SIZE to DB_BLOCK_BUFFERS

From: Rich Amick <rAmick_at_dotster.com>
Date: Wed, 23 Aug 2006 10:12:21 -0700
Message-ID: <19775.33521156353142.scalix0.corp.dotster.net@MHS>

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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Aug 23 2006 - 12:12:21 CDT