GV$AW_LONGOPS

select
inst_id,                 -- INST_ID NUMBER
session_id,              -- SESSION_ID NUMBER
cursor_name,             -- CURSOR_NAME VARCHAR2(64)
decode                   -- COMMAND VARCHAR2(7)
  (command, 1, 'FETCH', 2, 'IMPORT', 3, 'EXECUTE', '?'),
decode                   -- STATUS VARCHAR2(9)
  (status, 4, 'EXECUTING', 5, 'FETCHING', 6, 'FINISHED', '?'),
rows_processed,          -- ROWS_PROCESSED NUMBER
start_time               -- START_TIME TIMESTAMP(3)
from
x$xslongops
home |  up  |  mailbox