select
  memstate,                                -- MEMSTATE NUMBER
  state,                                   -- STATE VARCHAR2(9)
  owning_process                           -- OWNING_PROCESS NUMBER
from
  gv$logmnr_region
where
  inst_id = userenv('instance')