VIEW: SYS.DBA_DATAPUMP_SESSIONS

Source

View Text - Preformatted

SELECT  j.owner_name, j.job_name, s.inst_id, s.saddr, s.type
        FROM    SYS.GV$DATAPUMP_JOB j, SYS.GV$DATAPUMP_SESSION s
        WHERE   j.job_id = s.job_id

View Text - HTML Formatted

SELECT J.OWNER_NAME
, J.JOB_NAME
, S.INST_ID
, S.SADDR
, S.TYPE
FROM SYS.GV$DATAPUMP_JOB J
, SYS.GV$DATAPUMP_SESSION S
WHERE J.JOB_ID = S.JOB_ID