I am currently using the following query to find the
objects that are cached in the block buffer pool.
select a.status, b.object_name, count(*) total
from v$bh a, dba_objects b
where a.objd = b.object_id(+)
group by a.status, b.object_name;
It works fine. But, I'd really like to include the pool
in the output (keep, recycle, default). However, there
doesn't seem to be a field in v$bh (or even x$bh) that
corresponds to the pool.
Does anyone know how to get this information? I assume
I need to join with another table. Which one is it?