GV$DATAPUMP_SESSION

SELECT
inst_id,                 -- INST_ID NUMBER
kupvaid,                 -- ATTACH_ID NUMBER
kupvajobid,              -- JOB_ID RAW(16)
kupvasesaddr,            -- SADDR RAW(4)
decode                   -- TYPE VARCHAR2(14)
  (kupvasestype, 1, 'DBMS_DATAPUMP', 2, 'MASTER', 3, 'WORKER', 4, 'EXTERNAL TABLE', 'OTHER') 
FROM
x$kupva
home |  up  |  mailbox