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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
