Oracle database 14章 使用数据泵导出和导入 监控数据泵作业 理论试验

1、浏览数据泵作业

SQL> select * from dba_datapump_jobs;

no rows selected

SQL> select * from dba_datapump_jobs;

OWNER_NAME		       JOB_NAME
------------------------------ ------------------------------
OPERATION		       JOB_MODE
------------------------------ ------------------------------
STATE				   DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS
------------------------------ ---------- ----------------- -----------------
HR			       SYS_EXPORT_SCHEMA_01
EXPORT			       SCHEMA
EXECUTING				1		  1		    3


SQL> 

2、浏览数据泵会话

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

       SID    SERIAL#
---------- ----------
      1618	  179
      1806	   43
      1997	11189

SQL> 

3、浏览数据泵作业的进度

select opname, target_desc, sofar, totalwork from v$session_longops;