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.