How to find tables for keep and recycle buffer pool
The database version is 10.2.0.3
I am using following query for identifying the tables for keep pool .
SELECT obj object,
count(1) buffers,
AVG(tch) average_touch_count
FROM x$bh
WHERE lru_flag = 8
GROUP BY obj
HAVING avg(tch) > 5
AND count(1) > 25;
but it giving me error ---ORA-00980: synonym translation is no longer valid
How to find tables for keep cache