| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: recycle and keep buffer in other tablespace block sizes
Interesting question. You seem to have the easy test case in hand. Would you
query that table in, a non-keep flagged 2K in, and a keep flagged table in
and look at bh, et. al. to see where Oracle puts them?
The likely suspects are that Oracle will ignore the flag or Oracle will put it in the oversized keep space. Hmm. Wonder what would happen if your sizes (default and alternate) were reversed. Unlikely they'd fragment the block 8K into 4 by 2K, since I think the whole point of multiple cache sizes is to avoid handling variable block sizes within a single cache. Pretty easy to harbor an undersized block, but a real nuisance to cobble pieces together. I'm guessing they ignore the cache flag for non-default sizes. Possibly they slap "hot block" stats as regards LRU for those blocks, which would help a bit.
mwf
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Juan Carlos Reyes
Pacheco
Sent: Wednesday, July 21, 2004 11:24 AM
To: oracle-l_at_freelists.org
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
"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
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlReceived on Wed Jul 21 2004 - 11:04:47 CDT
-----------------------------------------------------------------
----------------------------------------------------------------
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
-----------------------------------------------------------------
 |
 |