-----------------------------------------------------------
-- what: blxncach.sql
--  who: Oracle Corp. 
--       (from the 10g Performance Tuning Guide)     
-- when: 12 April 2006
-----------------------------------------------------------
column object_name format a40
column number_of_blocks format 999,999,999,999

select o.object_name, count (*) number_of_blocks 
from dba_objects o, v$bh bh
where o.data_object_id = bh.objd
and o.owner != 'SYS'
group by o.object_name
order by count (*)
/