select
  inst_id,                                 -- INST_ID NUMBER
  session_id,                              -- SESSION_ID NUMBER
  cursor_name,                             -- CURSOR_NAME VARCHAR2(64)
  decode(                                  -- COMMAND VARCHAR2(17)
    command, 1, 'QUERY', 2, 'FETCH', 3, 'IMPORT', 4, 'EXECUTE', 5, 'UPDATE', 6, 'SOLVE', 7, 'CLEAR', 8, 'LOAD CUBE', 9, 'LOAD DIMENSION', 10, 'DIMENSION COMPILE', '?'),
  decode(                                  -- STATUS VARCHAR2(9)
    status, 1, 'EXECUTING', 2, 'FETCHING', 3, 'FINISHED', '?'),
  rows_processed,                          -- ROWS_PROCESSED NUMBER
  seq_number,                              -- SEQ_NUMBER NUMBER
  sql_id,                                  -- SQL_ID VARCHAR2(13)
  target,                                  -- TARGET VARCHAR2(64)
  target_desc,                             -- TARGET_DESC VARCHAR2(64)
  to_date(                                 -- START_TIME DATE
    start_time, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
  to_date(                                 -- LAST_UPDATE_TIME DATE
    last_update_time, 'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  elapsed_seconds,                         -- ELAPSED_SECONDS NUMBER
  sofar,                                   -- SOFAR NUMBER
  totalwork,                               -- TOTALWORK NUMBER
  decode (                                 -- UNITS VARCHAR2(6)
    units, 1, 'ROWS', 2, 'NODES', 3, 'VALUES', '?'),
  message,                                 -- MESSAGE VARCHAR2(512)
  username                                 -- USERNAME VARCHAR2(32)
from
  x$xslongops