Hi

A small correction

Use the following query after creating the view

select o.name, COUNT(buf#) BLOCKS
from obj$ o, x$bh x
where o.dataobj# = x.obj
and x.state != 0
and o.owner# !=0
and buf# >= (select lo_bnum from v$buffer_pool_lo_hi_bnum where
name = 'KEEP' and buffers > 0)
and buf# <= (select hi_bnum from v$buffer_pool_lo_hi_bnum where
name = 'KEEP' and buffers > 0)
group by o.name

IF you are 8.0.5 user v$buffer_pool instead of the view

Sorry for the mistake.

HTH
Santosh