select
  inst_id,                                 -- INST_ID NUMBER
  decode(                                  -- PROCESS VARCHAR2(9)
    MSTYP, 1,'RFS', 2,'MRP0', 3,'MR(fg)', 4,'ARCH', 5,'FGRD', 6,'LGWR', 7,'RFS(FAL)', 8,'RFS(NEXP)', 9,'LNS', 'UNKNOWN'),
  to_number(MSPID),                        -- PID NUMBER
  decode(                                  -- STATUS VARCHAR2(12)
    MSSTS, 0,'UNUSED', 1,'ALLOCATED', 2,'CONNECTED', 3,'ATTACHED', 4,'IDLE', 5,'ERROR', 6,'OPENING', 7,'CLOSING', 8,'WRITING', 9,'RECEIVING', 10,'ANNOUNCING', 11,'REGISTERING', 12,'WAIT_FOR_LOG', 13,'WAIT_FOR_GAP', 14,'APPLYING_LOG', 'UNKNOWN'),
  decode(                                  -- CLIENT_PROCESS VARCHAR2(8)
    MSPAR, 0,'N/A', 4,'ARCH', 5,'Archival', 6,'LGWR', 9,'LNS', 'UNKNOWN'),
  decode(                                  -- CLIENT_PID VARCHAR2(40)
    MSPPID, 0,'N/A', to_number(MSPPID)),
  decode(                                  -- CLIENT_DBID VARCHAR2(40)
    MSDBID, 0,'N/A', to_number(MSDBID)),
  decode(                                  -- GROUP# VARCHAR2(40)
    MSLNO, 0,'N/A', to_number(MSLNO)),
  to_number(MSRLC),                        -- RESETLOG_ID NUMBER
  to_number(MSTHR),                        -- THREAD# NUMBER
  to_number(MSSEQ),                        -- SEQUENCE# NUMBER
  to_number(MSBNO),                        -- BLOCK# NUMBER
  to_number(MSBCT),                        -- BLOCKS NUMBER
  to_number(MSDLY),                        -- DELAY_MINS NUMBER
  to_number(MSRCLT),                       -- KNOWN_AGENTS NUMBER
  to_number(MSACLT)                        -- ACTIVE_AGENTS NUMBER
from
  x$krssms