select
  INST_ID,                                 -- INST_ID NUMBER
  OPID_KWQMNC,                             -- QMNC_PID VARCHAR2(24)
  decode (                                 -- STATUS VARCHAR2(24)
    STATUS_KWQMNC, 0, 'DEAD', 1, 'INITIALIZING', 2, 'RUNNING TASK COORDINATOR', 3, 'WAITING', 4, 'ADDING SERVER', NULL),
  NSLAVES_KWQMNC,                          -- NUM_SERVERS NUMBER
  LASTSLVSTTIM_KWQMNC,                     -- LAST_SERVER_START_TIME TIMESTAMP(3) WITH TIME ZONE
  LASTSLVOPID_KWQMNC,                      -- LAST_SERVER_PID VARCHAR2(24)
  NEXTWAKETIM_KWQMNC,                      -- NEXT_WAKEUP_TIME TIMESTAMP(3) WITH TIME ZONE
  RDYTM_KWQMNC,                            -- NEXT_READY_TIME TIMESTAMP(3) WITH TIME ZONE
  EXPTM_KWQMNC,                            -- NEXT_EXPIRY_TIME TIMESTAMP(3) WITH TIME ZONE
  LASTWAITTIM_KWQMNC,                      -- LAST_WAIT_TIME TIMESTAMP(3) WITH TIME ZONE
  LASTFAILURE_KWQMNC,                      -- LAST_FAILURE VARCHAR2(32)
  LASTFAILTIM_KWQMNC,                      -- LAST_FAILURE_TIME TIMESTAMP(3) WITH TIME ZONE
  decode (                                 -- MAX_TASK_LATENCY VARCHAR2(40)
    NSLAVES_KWQMNC, 0, NULL, MAXLATENCY_KWQMNC),
  decode (                                 -- MIN_TASK_LATENCY VARCHAR2(40)
    NSLAVES_KWQMNC, 0, NULL, MINLATENCY_KWQMNC),
  TOTALLATENCY_KWQMNC,                     -- TOTAL_TASK_LATENCY NUMBER
  TOTALTASK_KWQMNC,                        -- TOTAL_TASKS_EXECUTED NUMBER
  MAXSLV_KWQMNC                            -- MAX_SERVERS NUMBER
from
  X$KWQMNC