GV$BH
select
bh.inst_id,              -- INST_ID NUMBER
file#,                   -- FILE# NUMBER
dbablk,                  -- BLOCK# NUMBER
class,                   -- CLASS# NUMBER
decode                   -- STATUS VARCHAR2(7)
  (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,                       -- XNC NUMBER
0,                       -- FORCED_READS NUMBER
0,                       -- FORCED_WRITES NUMBER
bh.le_addr,              -- LOCK_ELEMENT_ADDR RAW(4)
name,                    -- LOCK_ELEMENT_NAME NUMBER
le_class,                -- 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
from
x$bh bh,
x$le le 
where
bh.le_addr = le.le_addr (+)  

home |  up  |  mailbox