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 19:13:02 +0300
Message-ID: <OFE9E4A4E6.937E5E35-ONC2256ED8.0058DD7E-C2256ED8.0059CEBB@alise.lv> 





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_at_alise.lv


Sent by: oracle-l-bounce_at_freelists.org


21.07.2004 18:39


Please respond to oracle-l
 

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


-----------------------------------------------------------------






----------------------------------------------------------------

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 - 11:18:08 CDT












Original text of this message













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