How do I check my Datapump process?

We can check and monitor the details of data pump jobs using the following options:

1. By querying DBA_DATAPUMP_JOBS view:

   1	SQL > select * from dba_datapump_jobs;

2.  By querying V$SESSION_LONGOPS & V$SESSION views:

   1 2 3 4 5

   SQL > SELECT b.username, a.sid, b.opname, b.target,             round(b.SOFAR*100/b.TOTALWORK,0) || '%' as "%DONE", b.TIME_REMAINING,             to_char(b.start_time,'YYYY/MM/DD HH24:MI:SS') start_time      FROM v$session_longops b, v$session a      WHERE a.sid = b.sid      ORDER BY 6;

3. By querying V$SESSION_LONGOPS & V$DATAPUMP_JOB views:

   1 2 3 4

   SQL >  SELECT sl.sid, sl.serial#, sl.sofar, sl.totalwork, dp.owner_name, dp.state, dp.job_mode      FROM v$session_longops sl, v$datapump_job dp      WHERE sl.opname = dp.job_name      AND sl.sofar != sl.totalwork;

4. Using the datapump client (expdp & impdp) STATUS command