Listing A - Viewing the contents of the data buffer

select
 
       bp.name           pool_name,
 
       ob.name           object,
 
       ob.subname    sub_name,
 
       sum(buf_count) buffer_blocks
f
rom

       (select set_ds, obj, count(*) buf_count

       from x$bh group by set_ds, obj)                bh,

       obj$                 ob,

       x$kcbwds             ws,

       v$buffer_pool bp

where

   ob.dataobj# = bh.obj

and

   ob.owner# > 0

and

   bh.set_ds = ws.addr

and

   ws.set_id between bp.lo_setid and bp.hi_setid

group by

       bp.name,

       ob.name,

       ob.subname

order by

       bp.name,

       ob.name,

       ob.subname

;