监控impdp/expdp的进度方法

--监控impdp/expdp的进度方法--执行导出。[oracle@ocm1 ~]$ expdp system/oracle schemas=eoda directory=ext dumpfile=eoda.dmp--在视图中查找datapump的job_name。SYS@PROD1> select * from dba_datapump_jobs;                        OWNER_NAME       JOB_NAME------------------------------ ------------------------------OPERATION----------------------------------------------------------------------------------------------------JOB_MODE----------------------------------------------------------------------------------------------------STATE   DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS------------------------------ ---------- ----------------- -----------------SYSTEM       SYS_EXPORT_SCHEMA_01EXPORTSCHEMAEXECUTING1  1    3--设置attach为job_name即可查看进度。[oracle@ocm1 ~]$ expdp system/oracle attach=SYS_EXPORT_SCHEMA_01Export: Release 11.2.0.3.0 - Production on Fri Feb 10 20:59:24 2017Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsJob: SYS_EXPORT_SCHEMA_01  Owner: SYSTEM                           Operation: EXPORT                           Creator Privs: TRUE                             GUID: 482CA277B7350F88E053479DA8C00EFB  Start Time: Friday, 10 February, 2017 20:57:05  Mode: SCHEMA                           Instance: PROD1  Max Parallelism: 1  EXPORT Job Parameters:  Parameter Name      Parameter Value:     CLIENT_COMMAND        system/******** schemas=eoda directory=ext dumpfile=eoda.dmp   State: EXECUTING                        Bytes Processed: 2,113,260,264  Percent Done: 65  Current Parallelism: 1  Job Error Count: 0  Dump File: /home/oracle/ext/eoda.dmp    bytes written: 2,113,449,984  Worker 1 Status:  Process Name: DW00  State: EXECUTING                        Object Schema: EODA  Object Name: NEW_TABLE  Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA  Completed Objects: 3  Total Objects: 52  Completed Rows: 1,338,029  Worker Parallelism: 1