select
  session_id,                              -- SESSION_ID NUMBER
  name,                                    -- NAME VARCHAR2(32)
  child_addr,                              -- CHILD_ADDR RAW(8)
  state                                    -- STATE VARCHAR2(6)
from
  gv$logmnr_latch
where
  inst_id = userenv('instance')