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
home |  up  |  mailbox