Re: alter session set events = 'immediate trace name flush_cache'

You can try the following query.
It gives you the count of blocks in buffer cache for each object.

select o.owner,o.object_name,o.object_type,count(b.BLOCK#) "Blocks in Cache" from v$bh b, dba_objects o
where b.OBJD=o.data_object_id
group by o.owner,o.object_name,o.object_type order by 4 desc Received on Tue Jul 18 2006 - 08:33:44 CDT