监控Oracle数据泵状态

ps -ef |grep expdp

ps -ef |grep impdp

tail -f expdp.log

select 
   sid, 
   serial#
from 
   v$session s, 
   dba_datapump_sessions d
where 
   s.saddr = d.saddr;

select 
   sid, 
   serial#, 
   sofar, 
   totalwork
from 
   v$session_longops;

SELECT j.owner_name, j.job_name, j.job_mode, j.state, s.session_type, s.saddr
FROM dba_datapump_jobs j,dba_datapump_sessions s
WHERE UPPER(j.job_name) = UPPER(s.job_name);

expdp system/mypassword attach=SYSTEM.SYS_EXPORT_SCHEMA_01;

impdp user/password
attach='job_user.job_name'

impdp> status