select
  bh.inst_id,                              -- INST_ID NUMBER
  file#,                                   -- FILE# NUMBER
  dbablk,                                  -- BLOCK# NUMBER
  class,                                   -- CLASS# NUMBER
  decode(                                  -- STATUS VARCHAR2(10)
    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', 12,'protected', 13,'securefile', 14,'siop',15,'recckpt', 16, 'flashfree', 17, 'flashcur', 18, 'flashna'),
  0,                                       -- XNC NUMBER
  0,                                       -- FORCED_READS NUMBER
  0,                                       -- FORCED_WRITES NUMBER
  bh.le_addr,                              -- LOCK_ELEMENT_ADDR RAW(8)
  le_id1,                                  -- LOCK_ELEMENT_NAME NUMBER
  le_id2,                                  -- LOCK_ELEMENT_CLASS NUMBER
  decode(                                  -- DIRTY VARCHAR2(1)
    bitand(flag,1), 0, 'N', 'Y'),
  decode(                                  -- TEMP VARCHAR2(1)
    bitand(flag,16), 0, 'N', 'Y'),
  decode(                                  -- PING VARCHAR2(1)
    bitand(flag,1536), 0, 'N', 'Y'),
  decode(                                  -- STALE VARCHAR2(1)
    bitand(flag,16384), 0, 'N', 'Y'),
  decode(                                  -- DIRECT VARCHAR2(1)
    bitand(flag,65536), 0, 'N', 'Y'),
  'N',                                     -- NEW CHAR(1)
  obj,                                     -- OBJD NUMBER
  ts#,                                     -- TS# NUMBER
  lobid,                                   -- LOBID NUMBER
  bitand(OBJ_FLAG, 240)/16                 -- CACHEHINT NUMBER
from
  x$bh bh,
  x$le le
where
  bh.le_addr = le.le_addr (+)