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