select
  inst_id,                                 -- INST_ID NUMBER
  indx,                                    -- CONF_INDX NUMBER
  kmmdpnet,                                -- NETWORK VARCHAR2(1024)
  kmmdpopt,                                -- DISPATCHERS NUMBER
  kmmdpcon,                                -- CONNECTIONS NUMBER
  kmmdpses,                                -- SESSIONS NUMBER
  decode(                                  -- POOL VARCHAR2(4)
    bitand(kmmdpflg, 3), 0, 'OFF', 1, 'IN', 2, 'OUT', 'BOTH'),
  kmmdptck,                                -- TICKS NUMBER
  kmmdptin,                                -- INBD_TIMOUT NUMBER
  kmmdptou,                                -- OUTBD_TIMOUT NUMBER
  decode(                                  -- MULTIPLEX VARCHAR2(4)
    bitand(kmmdpflg, 12), 0, 'OFF', 4, 'IN', 8, 'OUT', 'BOTH'),
  kmmdplsn,                                -- LISTENER VARCHAR2(1200)
  kmmdpsnm                                 -- SERVICE VARCHAR2(512)
from
  x$kmmdp