Re: recycle and keep buffer in other tablespace block sizes

Those are hidden! Try:
__DB_2K_KEEP_CACHE_SIZE
__DB_2K_RECYCLE_CACHE_SIZE

Just joken ;)
There no K/R/D for diferent block sizes. Just one cache per block size ;)

Jurijs
9268222
============================================
http://otn.oracle.com/ocm/jvelikanovs.html






"Juan Carlos Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx>
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
21.07.2004 16:57
Please respond to oracle-l
 
        To:     <oracle-l@xxxxxxxxxxxxx>
        cc: 
        Subject:        recycle and keep buffer in other tablespace block 
sizes


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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------



----------------------------------------------------------------
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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: