select
  s.INST_ID,                               -- INST_ID NUMBER
  c.OPID_KWQMNC,                           -- QMNC_PID VARCHAR2(24)
  s.OPID_KWQMNSCTX,                        -- SERVER_PID VARCHAR2(24)
  s.PNAME_KWQMNSCTX,                       -- SERVER_NAME VARCHAR2(64)
  decode (                                 -- STATUS VARCHAR2(40)
    s.STATUS_KWQMNSCTX, 0, 'UNUSED', 1, 'RUNNING', 2, 'IDLE WAIT', 3, 'RUNNING', 4, 'RUNNING', 5, 'RUNNING', 6, 'EXITING', 7, 'NOT ACTIVE', s.STATUS_KWQMNSCTX),
  s.STTIME_KWQMNSCTX,                      -- SERVER_START_TIME TIMESTAMP(3) WITH TIME ZONE
  (case                                    -- TASK_NAME VARCHAR2(32) 
     when (s.STATUS_KWQMNSCTX >= 3 and s.STATUS_KWQMNSCTX <= 5) 
     then ( 
    select
      stat.TASKNAME_KWQMNCTID
    from
      X$KWQMNTASKSTAT stat
    where
      stat.TASKID_KWQMNCTID = s.TSKID_KWQMNSCTX and stat.INST_ID = s.INST_ID) else NULL end), 
  (case                                    -- TASK_NUMBER NUMBER
     when (s.STATUS_KWQMNSCTX >= 3 and s.STATUS_KWQMNSCTX <= 5) 
     then s.TSKNUM_KWQMNSCTX else NULL end), 
  (case                                    -- TASK_START_TIME TIMESTAMP(3) WITH TIME ZONE
     when (s.STATUS_KWQMNSCTX >= 3 and s.STATUS_KWQMNSCTX <= 5) 
     then s.TSKSTTIME_KWQMNSCTX else NULL end), 
  s.LSTWTTM_KWQMNSCTX,                     -- LAST_WAIT_TIME TIMESTAMP(3) WITH TIME ZONE
  s.MAXLAT_KWQMNSCTX,                      -- MAX_LATENCY NUMBER
  s.MINLAT_KWQMNSCTX,                      -- MIN_LATENCY NUMBER
  s.TOTALLAT_KWQMNSCTX,                    -- TOTAL_LATENCY NUMBER
  s.NUMTASK_KWQMNSCTX,                     -- NUM_TASKS NUMBER
  s.LASTFAILURE_KWQMNSCTX,                 -- LAST_FAILURE VARCHAR2(32)
  s.LASTFAILTIM_KWQMNSCTX,                 -- LAST_FAILURE_TIME TIMESTAMP(3) WITH TIME ZONE
  (                                        -- LAST_FAILURE_TASK VARCHAR2(32)
  select
    stat.TASKNAME_KWQMNCTID
  from
    X$KWQMNTASKSTAT stat
  where
    stat.TASKID_KWQMNCTID = s.LASTFAILTSKID_KWQMNSCTX and stat.INST_ID = s.INST_ID), 
  s.LASTFAILTSKNUM_KWQMNSCTX               -- LAST_FAILURE_TASKNUM NUMBER
from
  X$KWQMNSCTX s,
  X$KWQMNC c
where
  s.STATUS_KWQMNSCTX <> 0 and s.INST_ID = c.INST_ID