--监控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_01
EXPORT
SCHEMA
EXECUTING 1 1 3
--设置attach为job_name即可查看进度。
[oracle@ocm1 ~]$ expdp system/oracle attach=SYS_EXPORT_SCHEMA_01
Export: Release 11.2.0.3.0 - Production on Fri Feb 10 20:59:24 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Job: 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
————————————————
版权声明:本文为CSDN博主「blockheading」的原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/u013169075/article/details/54974056
监控impdp/expdp的进度方法
最新推荐文章于 2023-05-26 14:01:15 发布