Ask about KEEP pool

   Hi all,

   My version is 9.2.0.4 64 bit on Unix.

   About Multiple Buffer Pools, I want configure KEEP POOL for some objects. But I want clear some problem, I give a specify case such as:

   

   1. I need determine which segments have many buffers in pool. This work mean these segments frequently accessed ?

    I used bellow script :

SELECT o.object_name, COUNT(1) number_of_blocks   

FROM DBA_OBJECTS o, V$BH bh  

WHERE o.object_id  = bh.objd    

AND o.owner     = 'TEST'

AND OBJECT_NAME = 'TEST_ACCOUNT'  

GROUP BY o.object_name  ORDER BY count(1);

   And value returned is: 14982. This result mean is number of data blocks TEST_ACCOUNT reside in buffer cahe.