Database Administration (MOSC)

MOSC Banner

How to find tables for keep and recycle buffer pool

edited Apr 22, 2009 4:04AM in Database Administration (MOSC) 2 commentsAnswered
 Hello everybody ,

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



Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center