GV$LOGMNR_REGION select inst_id, -- INST_ID NUMBER memstate, -- MEMSTATE NUMBER decode -- STATE VARCHAR2(9) (state, 0, 'INIT', 1, 'AVAIL', 2, 'ASSIGNED', 3, 'PREPARED', 4, 'ASSEMBLED'), owning_process -- OWNING_PROCESS NUMBER from x$logmnr_region