select
  inst_id,                                 -- INST_ID NUMBER
  kmcqspro,                                -- PADDR RAW(8)
  decode(                                  -- TYPE VARCHAR2(10)
    bitand(kmcqstyp,1),1,'COMMON','DISPATCHER'),
  kmcqsncq,                                -- QUEUED NUMBER
  kmcqswat,                                -- WAIT NUMBER
  kmcqstnc                                 -- TOTALQ NUMBER
from
  x$kmcqs
where
  bitand(kmcqsflg,1) = 1 and bitand(kmcqstyp,3) != 0 and (bitand(kmcqstyp,8) = 8 or bitand(kmcqstyp,2) = 2 or kmcqstnc > 0)