Help with query to find buffer pool usage

Greetings.

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?

• Rich