select
  inst_id,                                 -- INST_ID NUMBER
  kmmdinam,                                -- NAME VARCHAR2(4)
  kmmdipro,                                -- PADDR RAW(8)
  kmmdicrle,                               -- CUR_LOOP_RATE NUMBER
  kmmdicre,                                -- CUR_EVENT_RATE NUMBER
  kmmdicepl,                               -- CUR_EVENTS_PER_LOOP NUMBER
  kmmdicrm,                                -- CUR_MSG_RATE NUMBER
  kmmdicrus,                               -- CUR_SVR_BUF_RATE NUMBER
  kmmdicrys,                               -- CUR_SVR_BYTE_RATE NUMBER
  kmmdicyus,                               -- CUR_SVR_BYTE_PER_BUF NUMBER
  kmmdicruc,                               -- CUR_CLT_BUF_RATE NUMBER
  kmmdicryc,                               -- CUR_CLT_BYTE_RATE NUMBER
  kmmdicyuc,                               -- CUR_CLT_BYTE_PER_BUF NUMBER
  kmmdicru,                                -- CUR_BUF_RATE NUMBER
  kmmdicry,                                -- CUR_BYTE_RATE NUMBER
  kmmdicyu,                                -- CUR_BYTE_PER_BUF NUMBER
  kmmdicic,                                -- CUR_IN_CONNECT_RATE NUMBER
  kmmdicoc,                                -- CUR_OUT_CONNECT_RATE NUMBER
  kmmdicrr,                                -- CUR_RECONNECT_RATE NUMBER
  kmmdimrle,                               -- MAX_LOOP_RATE NUMBER
  kmmdimre,                                -- MAX_EVENT_RATE NUMBER
  kmmdimepl,                               -- MAX_EVENTS_PER_LOOP NUMBER
  kmmdimrm,                                -- MAX_MSG_RATE NUMBER
  kmmdimrus,                               -- MAX_SVR_BUF_RATE NUMBER
  kmmdimrys,                               -- MAX_SVR_BYTE_RATE NUMBER
  kmmdimyus,                               -- MAX_SVR_BYTE_PER_BUF NUMBER
  kmmdimruc,                               -- MAX_CLT_BUF_RATE NUMBER
  kmmdimryc,                               -- MAX_CLT_BYTE_RATE NUMBER
  kmmdimyuc,                               -- MAX_CLT_BYTE_PER_BUF NUMBER
  kmmdimru,                                -- MAX_BUF_RATE NUMBER
  kmmdimry,                                -- MAX_BYTE_RATE NUMBER
  kmmdimyu,                                -- MAX_BYTE_PER_BUF NUMBER
  kmmdimic,                                -- MAX_IN_CONNECT_RATE NUMBER
  kmmdimoc,                                -- MAX_OUT_CONNECT_RATE NUMBER
  kmmdimrr,                                -- MAX_RECONNECT_RATE NUMBER
  kmmdiarle,                               -- AVG_LOOP_RATE NUMBER
  kmmdiare,                                -- AVG_EVENT_RATE NUMBER
  kmmdiaepl,                               -- AVG_EVENTS_PER_LOOP NUMBER
  kmmdiarm,                                -- AVG_MSG_RATE NUMBER
  kmmdiarus,                               -- AVG_SVR_BUF_RATE NUMBER
  kmmdiarys,                               -- AVG_SVR_BYTE_RATE NUMBER
  kmmdiayus,                               -- AVG_SVR_BYTE_PER_BUF NUMBER
  kmmdiaruc,                               -- AVG_CLT_BUF_RATE NUMBER
  kmmdiaryc,                               -- AVG_CLT_BYTE_RATE NUMBER
  kmmdiayuc,                               -- AVG_CLT_BYTE_PER_BUF NUMBER
  kmmdiaru,                                -- AVG_BUF_RATE NUMBER
  kmmdiary,                                -- AVG_BYTE_RATE NUMBER
  kmmdiayu,                                -- AVG_BYTE_PER_BUF NUMBER
  kmmdiaic,                                -- AVG_IN_CONNECT_RATE NUMBER
  kmmdiaoc,                                -- AVG_OUT_CONNECT_RATE NUMBER
  kmmdiarr,                                -- AVG_RECONNECT_RATE NUMBER
  kmmdinrle,                               -- TTL_LOOPS NUMBER
  kmmdinrm,                                -- TTL_MSG NUMBER
  kmmdinrus,                               -- TTL_SVR_BUF NUMBER
  kmmdinruc,                               -- TTL_CLT_BUF NUMBER
  kmmdinru,                                -- TTL_BUF NUMBER
  kmmdinic,                                -- TTL_IN_CONNECT NUMBER
  kmmdinoc,                                -- TTL_OUT_CONNECT NUMBER
  kmmdinrr,                                -- TTL_RECONNECT NUMBER
  kmmdisrle,                               -- SCALE_LOOPS NUMBER
  kmmdisrm,                                -- SCALE_MSG NUMBER
  kmmdisrus,                               -- SCALE_SVR_BUF NUMBER
  kmmdisruc,                               -- SCALE_CLT_BUF NUMBER
  kmmdisru,                                -- SCALE_BUF NUMBER
  kmmdisic,                                -- SCALE_IN_CONNECT NUMBER
  kmmdisoc,                                -- SCALE_OUT_CONNECT NUMBER
  kmmdisrr                                 -- SCALE_RECONNECT NUMBER
from
  x$kmmdi
where
  kmmdiflg!=0