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')