Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: recycle and keep buffer in other tablespace block sizes

Re: recycle and keep buffer in other tablespace block sizes

From: <J.Velikanovs_at_alise.lv>
Date: Wed, 21 Jul 2004 18:39:04 +0300
Message-ID: <OF7B0D64E0.33509128-ONC2256ED8.0055F240-C2256ED8.0056B270@alise.lv>


Good point :)
I am going to check.

Jurijs
9268222



http://otn.oracle.com/ocm/jvelikanovs.html

"Juan Carlos Reyes Pacheco" <jreyes_at_dazasoftware.com> Sent by: oracle-l-bounce_at_freelists.org
21.07.2004 18:23
Please respond to oracle-l  

        To:     <oracle-l_at_freelists.org>
        cc: 
        Subject:        Re: recycle and keep buffer in other tablespace 
block sizes

Hi Jurijs, thanks,
 my default block size is 8K
If have a table in a 2k tablespace with the flag to be cached in the keep pool.
How it is cached?
It takes 8K???? in the keep cache
Could you please give more information :)

-------Original Message-------
 

From: oracle-l_at_freelists.org
Date: 07/21/04 11:00:14
To: oracle-l_at_freelists.org
Subject: 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_at_dazasoftware.com> Sent by: oracle-l-bounce_at_freelists.org
21.07.2004 16:57
Please respond to oracle-l  

To: <oracle-l_at_freelists.org>
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_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
     

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

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


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:56:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US