--v$bh
select file#,
         block#,
         class#,
         status,
         xnc,
         forced_reads,
         forced_writes,
         lock_element_addr,
         lock_element_name,
         lock_element_class,
         dirty,
         temp,
         ping,
         stale,
         direct,
         new,
         objd,
         ts#
    from gv$bh
   where inst_id = USERENV('Instance');
   --GV$BH
select bh.inst_id,
         file#,
         dbablk,
         class,
         decode(state,
                0,
                'free',
                1,
                'xcur',
                2,
                'scur',
                3,
                'cr',
                4,
                'read',
                5,
                'mrec',
                6,
                'irec',
                7,
                'write',
                8,
                'pi'),
         x_to_null,
         forced_reads,
         forced_writes,
         bh.le_addr,
         name,
         le_class,
         decode(bitand(flag, 1), 0, 'N', 'Y'),
         decode(bitand(flag, 16), 0, 'N', 'Y'),
         decode(bitand(flag, 1536), 0, 'N', 'Y'),
         decode(bitand(flag, 16384), 0, 'N', 'Y'),
         decode(bitand(flag, 65536), 0, 'N', 'Y'),
         'N',
         obj,
         ts#
    from x$bh bh, x$le le
   where bh.le_addr = le.le_addr(+);

V$BH,gv$bh结构