select
  inst_id,                                 -- INST_ID NUMBER
  session_id,                              -- SESSION_ID NUMBER
  name,                                    -- NAME VARCHAR2(32)
  child_addr,                              -- CHILD_ADDR RAW(8)
  decode(                                  -- STATE VARCHAR2(6)
    state, 0, 'UNINIT', 1, 'READY') state 
from
  x$logmnr_latch