SYS:jozh> @par Parameters vai dala no ta :db_block_size NAME VALUE ---------------------------------------- ------------------------------------------------------- db_block_size 8192 SYS:jozh> @par Parameters vai dala no ta :db_2k_cache_size NAME VALUE ---------------------------------------- --------------------- db_2k_cache_size 0 SYS:jozh> CREATE TABLESPACE TEST2K SYS:jozh> DATAFILE 'D:\ORACLE\ORADATA\JOZH\TEST2K.ora' SIZE 5M SYS:jozh> BLOCKSIZE 2K; CREATE TABLESPACE TEST2K * ERROR at line 1: ORA-29339: tablespace block size 2048 does not match configured block sizes have added db_2k_cache_size=10M to init.ora SYS:jozh> @par Parameters vai dala no ta :db_2k_cache_size NAME VALUE ---------------------------------------- ---------- db_2k_cache_size 12582912 SYS:jozh> CREATE TABLESPACE TEST2K SYS:jozh> DATAFILE 'D:\ORACLE\ORADATA\JOZH\TEST2K.ora' SIZE 5M SYS:jozh> BLOCKSIZE 2K; Tablespace created. SYS:jozh> create table test2ktab (n number) tablespace test2k; Table created. SYS:jozh> begin SYS:jozh> for f in 1..10000 loop SYS:jozh> insert into test2ktab values (f); SYS:jozh> end loop; commit; SYS:jozh> end; SYS:jozh> / PL/SQL procedure successfully completed. SYS:jozh> have removed db_2k_cache_size from init.ora SYS:jozh> select DATA_OBJECT_ID from dba_objects where object_name = 'TEST2KTAB'; DATA_OBJECT_ID -------------- 10047 SYS:jozh> select count(*) from test2ktab; COUNT(*) ---------- 10000 SYS:jozh> select count(*) from v$bh where OBJD=100047; COUNT(*) ---------- 0 Any ideas? Where I go wrong? Jurijs 9268222 ============================================ http://otn.oracle.com/ocm/jvelikanovs.html J.Velikanovs@xxxxxxxx Sent by: oracle-l-bounce@xxxxxxxxxxxxx 21.07.2004 18:39 Please respond to oracle-l To: oracle-l@xxxxxxxxxxxxx cc: Subject: Re: recycle and keep buffer in other tablespace block sizes Good point :) I am going to check. Jurijs 9268222 ============================================ http://otn.oracle.com/ocm/jvelikanovs.html "Juan Carlos Reyes Pacheco" <jreyes@xxxxxxxxxxxxxxxx> Sent by: oracle-l-bounce@xxxxxxxxxxxxx 21.07.2004 18:23 Please respond to oracle-l To: <oracle-l@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxx Date: 07/21/04 11:00:14 To: oracle-l@xxxxxxxxxxxxx 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@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 //www.freelists.org/archives/oracle-l/ FAQ is at //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 //www.freelists.org/archives/oracle-l/ FAQ is at //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 //www.freelists.org/archives/oracle-l/ FAQ is at //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 //www.freelists.org/archives/oracle-l/ FAQ is at //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 //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------