Re: recycle and keep buffer in other tablespace block sizes

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Wed, 21 Jul 2004 09:23:44 -0600
Message-Id: <6.1.0.6.2.20040721092025.02cce010@pop.centrexcc.com>

You can not. Keep and recycle pools are only possible for the default block size.

At 07:57 AM 7/21/2004, you wrote:
>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;
Regards

Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com

---

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 - 10:36:44 CDT