select
  inst_id,                                 -- INST_ID NUMBER
  ksulosno,                                -- SID NUMBER
  ksulosrn,                                -- SERIAL# NUMBER
  ksulopna,                                -- OPNAME VARCHAR2(64)
  ksulotna,                                -- TARGET VARCHAR2(64)
  ksulotde,                                -- TARGET_DESC VARCHAR2(32)
  ksulosfr,                                -- SOFAR NUMBER
  ksulotot,                                -- TOTALWORK NUMBER
  ksulouni,                                -- UNITS VARCHAR2(32)
  to_date(                                 -- START_TIME DATE
    ksulostm,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  to_date(                                 -- LAST_UPDATE_TIME DATE
    ksulolut,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  to_date(                                 -- TIMESTAMP DATE
    ksuloinft, 'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  decode(                                  -- TIME_REMAINING NUMBER
    ksulopna, 'Advisor', ksuloif2, decode(sign(ksulotot-ksulosfr),-1,to_number(NULL), decode(ksulosfr, 0, to_number(NULL), round(ksuloetm*((ksulotot-ksulosfr)/ksulosfr))))),
  ksuloetm,                                -- ELAPSED_SECONDS NUMBER
  ksuloctx,                                -- CONTEXT NUMBER
  ksulomsg,                                -- MESSAGE VARCHAR2(512)
  ksulounm,                                -- USERNAME VARCHAR2(30)
  ksulosql,                                -- SQL_ADDRESS RAW(8)
  ksulosqh,                                -- SQL_HASH_VALUE NUMBER
  ksulosqi,                                -- SQL_ID VARCHAR2(13)
  ksulosqph,                               -- SQL_PLAN_HASH_VALUE NUMBER
  ksulosqesta,                             -- SQL_EXEC_START DATE
  decode(                                  -- SQL_EXEC_ID NUMBER
    ksulosqeid, 0, to_number(NULL), ksulosqeid),
  decode(                                  -- SQL_PLAN_LINE_ID NUMBER
    ksulosqplid, 0, to_number(NULL), ksulosqplid),
  ksulosqplop,                             -- SQL_PLAN_OPERATION VARCHAR2(30)
  ksulosqplnm,                             -- SQL_PLAN_OPTIONS VARCHAR2(30)
  ksuloqid                                 -- QCSID NUMBER
from
  x$ksulop