Oracle Database Data Pump Monitor Datapump jobs
Example
Datapump jobs can be monitored using
1. data dictionary views:
select * from dba_datapump_jobs;
SELECT * FROM DBA_DATAPUMP_SESSIONS;
select username,opname,target_desc,sofar,totalwork,message from V$SESSION_LONGOPS where username = 'bkpadmin';
2. Datapump status:
- Note down the job name from the import/export logs or data dictionary name and
- Run attach command:
- type status in Import/Export prompt
impdp <bkpadmin>/<bkp123> attach=<SYS_IMPORT_SCHEMA_01>
Import> status
Press press CTRL+C to come out of Import/Export prompt
