select
  inst_id,                                 -- INST_ID NUMBER
  kmmsinam,                                -- NAME VARCHAR2(4)
  kmmsiprp,                                -- PADDR RAW(8)
  kmmsista,                                -- STATUS VARCHAR2(16)
  kmmsinmg,                                -- MESSAGES NUMBER
  kmmsinmb,                                -- BYTES NUMBER
  kmmsibrk,                                -- BREAKS NUMBER
  kmmsivcp,                                -- CIRCUIT RAW(8)
  kmmsiidl,                                -- IDLE NUMBER
  kmmsibsy,                                -- BUSY NUMBER
  kmmsineti,                               -- IN_NET NUMBER
  kmmsineto,                               -- OUT_NET NUMBER
  kmmsitnc                                 -- REQUESTS NUMBER
from
  x$kmmsi
where
  bitand(kmmsiflg,1)!=0