| 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
Thanks in reward I give you this quick reference
http://www.larsditzel.de/9iquickref.pdf
Juan Carlos Reyes Pacheco
OCP
-------Original Message-------
From: oracle-l_at_freelists.org
Date: 08/02/04 12:41:41
To: oracle-l_at_freelists.org
Subject: Re: recycle and keep buffer in other tablespace block sizes
I have returned to this question.
Have retested issue and answer is:
Even if you set to non default block size table pool to keep it will go to
pool with nondefault block size (in our case to db_2k_cache_size).
I tried to create table with nondefault blocksize (2k) in 8k database,
then I have commented parameter db_2k_cache_size and you can see results
below.
My test prove that 2K table cant be cached in 8K pool, so it will not go
to keep pool in any case.
Jurijs
SYS:TEST5> @par
Parameters vai dala no ta :db_2k_cache_size
NAME VALUE
---------------------------------------- -----db_2k_cache_size 0
SYS:TEST5> select * from test2k;
select * from test2k
*
ERROR at line 1:
ORA-00379: no free buffers available in buffer pool DEFAULT for block size
2K
SYS:TEST5> select * from dba_data_files;
select * from dba_data_files
*
ERROR at line 1:
ORA-00379: no free buffers available in buffer pool DEFAULT for block size
2K
SYS:TEST5>
NAME VALUE
---------------------------------------- --------db_2k_cache_size 16777216
SYS:TEST5> create tablespace test2k datafile '/u01/oradata/TEST5/test2k01.dbf' size 10M blocksize 2K ;
Tablespace created.
SYS:TEST5> create table test2k (n number) tablespace test2k;
Table created.
SYS:TEST5> insert into test2k values (1);
1 row created.
SYS:TEST5> commit;
Commit complete.
SYS:TEST5> select * from test2k;
N
1 row selected.
SYS:TEST5>
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.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 Mon Aug 02 2004 - 15:18:37 CDT
 |
 |