select
  inst_id,                                 -- INST_ID NUMBER
  to_number(kcrrxpid),                     -- PROCESS NUMBER
  decode(                                  -- STATUS VARCHAR2(10)
    kcrrxsts, 1,'SCHEDULED', 2,'STARTING', 3,'ACTIVE', 4,'STOPPING', 5,'TERMINATED', 6,'INITING', 'STOPPED'),
  to_number(kcrrxseq),                     -- LOG_SEQUENCE NUMBER
  decode(                                  -- STATE VARCHAR2(4)
    kcrrxsta, 1,'BUSY', 'IDLE') 
from
  x$kcrrarch