select
  SESSION_ID,                              -- SESSION_ID NUMBER
  CURSOR_NAME,                             -- CURSOR_NAME VARCHAR2(64)
  COMMAND,                                 -- COMMAND VARCHAR2(17)
  STATUS,                                  -- STATUS VARCHAR2(9)
  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)
  START_TIME,                              -- START_TIME DATE
  LAST_UPDATE_TIME,                        -- LAST_UPDATE_TIME DATE
  ELAPSED_SECONDS,                         -- ELAPSED_SECONDS NUMBER
  SOFAR,                                   -- SOFAR NUMBER
  TOTALWORK,                               -- TOTALWORK NUMBER
  UNITS,                                   -- UNITS VARCHAR2(6)
  MESSAGE,                                 -- MESSAGE VARCHAR2(512)
  USERNAME                                 -- USERNAME VARCHAR2(32)
from
  gv$aw_longops
where
  inst_id = USERENV('Instance')