recycle and keep buffer in other tablespace block sizes

From: Juan Carlos Reyes Pacheco <jreyes_at_dazasoftware.com>
Date: Wed, 21 Jul 2004 09:57:32 -0400
Message-Id: <40FE764C.000007.00336@CACHITOSS>

Hi list I'm investigating this,
if your default blocksize is 8k, and you create a tables using 2k block you have the
ALTER SYSTEM SET DB_2K_CACHE_SIZE = 100M; to set the size for this block cache  

But how do you set the keep and recycle size for this block size There are none of this parameter.
ALTER SYSTEM SET DB_2K_KEEP_CACHE_SIZE = 1M; ALTER SYSTEM SET DB_2K_RECYCLE_CACHE_SIZE = 1M;   Thank you  

Juan Carlos Reyes Pacheco
OCP

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Wed Jul 21 2004 - 09:32:31 CDT