select
  inst_id,                                 -- INST_ID NUMBER
  kmmdinam,                                -- NAME VARCHAR2(4)
  kmmdiadd,                                -- NETWORK VARCHAR2(1024)
  kmmdipro,                                -- PADDR RAW(8)
  kmmdista,                                -- STATUS VARCHAR2(16)
  decode(kmmdiacc,0,'NO','YES'),           -- ACCEPT VARCHAR2(3)
  kmmdinmg,                                -- MESSAGES NUMBER
  kmmdinmb,                                -- BYTES NUMBER
  kmmdibrk,                                -- BREAKS NUMBER
  kmmdinvo,                                -- OWNED NUMBER
  kmmditnc,                                -- CREATED NUMBER
  kmmdiidl,                                -- IDLE NUMBER
  kmmdibsy,                                -- BUSY NUMBER
  kmmdiler,                                -- LISTENER NUMBER
  kmmdidci                                 -- CONF_INDX NUMBER
from
  x$kmmdi
where
  kmmdiflg != 0