candidate for buffer pools

[steeve123]

this is a query that find a good candidate for putting object in the buffer pool keep.


--Candidat pour le keep pool.
select obj object,
count(1) buffers,
avg(tch) avg_touches
from
x$bh,
(select value totsize from v$parameter where name = 'db_block_buffers')
where
lru_flag = 8
group by obj
having avg(tch) > 5
and count(1) > 20;




How can i know, what is the object?

ex of result:

OBJECT BUFFERS AVG_TOUCHES
--------- --------- -----------
27004 7 14.857143
27082 25 4.28
27158 6 3.1666667
28022 8 5.375

i want to know what is the table or the index or whaterver.

[pando]

well I guess object would be the object_id in dba_objects

[jmodic]

Actualy it is DATA_OBJECT_ID from DBA_OBJECTS, not OBJECT_ID.