有一台11.2.0.4的库最近expdp导出非常慢,总是停留在99%以后还要持续2个多小时,还有另外一台同版本的数据库也碰到了类似的情况。 Job: SYS_EXPORT_SCHEMA_01 Owner: XXX Operation: EXPORT Creator Privs: TRUE GUID: 8A27A5FA09F142F9E055000000000001 Start Time: Mode: SCHEMA Instance: Max Parallelism: 4 EXPORT Job Parameters: Parameter Name Parameter Value: CLIENT_COMMAND backup_user/******** dumpfile= COMPRESSION ALL State: EXECUTING Bytes Processed: 45,234,549,312 Percent Done: 99 Current Parallelism: 4 Job Error Count: 0 当前导出的对象都是一些空的分区,查询导出任务是否在等待 SQL> select dw.waiting_session, dw.holding_session, b.serial#, w.event, w.program wprogram, b.program bprogram, w.module wmod, b.module bmod, LOCK_ID1 from sys.dba_waiters dw, v$session w, v$session b where dw.waiting_session = w.sid and dw.holding_session = b.sid and (w.module like 'Data Pump%' or w.program like……

阅读全文