查询datapump相关信息

--查询datapump的sid信息
SELECT sid,
       serial#,
       session_type
FROM   v$session             s,
       dba_datapump_sessions d
WHERE  s.saddr = d.saddr;

--查询datapump的基本信息
SELECT owner_name,
       job_name,
       operation,
       job_mode,
       state,
       degree,
       attached_sessions,
       datapump_sessions
FROM   dba_datapump_jobs;

--查询datapump进度
SELECT sid,
       serial#,
       CONTEXT,
       sofar,
       totalwork,
       round(sofar / totalwork * 100, 2) "%_COMPLETE"
FROM   v$session_longops
WHERE  opname LIKE '%EXP%'
       OR opname LIKE '%IMP%'
       AND totalwork != 0
       AND sofar <> totalwork;