VIEW_NAME -->GV$BH
------------------------------------------------------------
VIEW_DEFINITION
------------------------------------------------------------
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',
               9, 'memory',
               10, 'mwrite',
               11, 'donated'
              ),
       0, 0, 0, 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(+);