/* Formatted on 24-Nov-2009 16:42:56 (QP5 v5.126) */
  SELECT   owner || '.' || object_name object,
           SUM (CASE WHEN b.status LIKE 'flash%' THEN 1 END) flash_blocks,
           SUM (CASE WHEN b.status LIKE 'flash%' THEN 0 else 1 END) cache_blocks,
           count(*) total_blocks  
    FROM       v$bh b
           JOIN
               dba_objects
           ON (objd = object_id)
GROUP BY   owner, object_name
order by 4 desc 
