Re: recycle and keep buffer in other tablespace block sizes
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 21 Jul 2004 09:23:44 -0600
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
