BUFFER POOL KEEP/RECYCLE

From: Nirmal Kumar Muthu Kumaran <NIRMALK_at_qtel.com.qa>
Date: Thu, 10 Jan 2002 04:37:08 -0800
Message-ID: <F001.003EC036.20020110041519@fatcity.com>

Hi all,

init.ora

---

db_block_size = 2048
db_block_buffers = 10240
db_block_lru_latches=3

buffer_pool_keep=(buffer:1024, lru_latches:1) buffer_pool_recycle=(buffer:512, lru_latches:1)

After instance startup,

SYS_at_SECDB> select name, value from v$parameter where name like 'buffer_pool%'

NAME                                                         VALUE
------------------------------------------------------------
-----------------------------
buffer_pool_keep                                             buffers:1024,

lru_latches:1
buffer_pool_recycle

Q1. Why here buffer pool recycle showing null value?

and,

SYS_at_SECDB> select table_name, BLOCKS, BUFFER_POOL from DBA_tables where buffer_pool ='KEEP'

TABLE_NAME                        BLOCKS BUFFER_
------------------------------ --------- -------
PPS_SERVICE                          418 KEEP
EMPPP                                  2 KEEP
TEST                                1796 KEEP

Here the total blocks in buffer pool keep or exceeded than the defied value, but oracle didn't give any error
while assing the object for buffer pool.

Q2. What is the logic behind on it, then?

Thanks to all.,
Nirmal.

<<application/ms-tnef>> Received on Thu Jan 10 2002 - 06:37:08 CST