select 'KEEP' BUFFER, sum(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 min(START_BUF#) lo_bnum from v$buffer_pool v, x$kcbwds s where name='KEEP' and 
LO_SETID=SET_ID and buffers > 0)
and buf# <= (select max(END_BUF#) hi_bnum from v$buffer_pool v, x$kcbwds s where name='KEEP' and
HI_SETID=SET_ID and buffers > 0)
group by buf#
union
select 'DEFAULT' BUFFER, sum(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 min(START_BUF#) lo_bnum from v$buffer_pool v, x$kcbwds s where name='DEFAULT' and 
LO_SETID=SET_ID and buffers > 0)
and buf# <= (select max(END_BUF#) hi_bnum from v$buffer_pool v, x$kcbwds s where name='DEFAULT' and
HI_SETID=SET_ID and buffers > 0)
group by buf#
union
select 'RECYCLE' BUFFER, sum(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 min(START_BUF#) lo_bnum from v$buffer_pool v, x$kcbwds s where name='RECYCLE' and
LO_SETID=SET_ID and buffers > 0)
and buf# <= (select max(END_BUF#) hi_bnum from v$buffer_pool v, x$kcbwds s where name='RECYCLE' and
HI_SETID=SET_ID and buffers > 0)
group by buf#
/