刘大，你好，我遇到以下问题，求助！
AIX oracle 11.2.0.3 expdp 导出分区表时卡住，一直处在以下界面，status查看一直在处理对象，但是很慢，schema下有45张表，表分区有1万5千多
用exp能正常导出
这是什么原因呐？

刘大，辛苦！
我重新测试了下
============================表分区信息如下============================
select count(*) from dba_tab_partitions where table_owner='TT'
count(*)
15615
select count(*) from dba_tab_su
bp
artitions where table_owner='TT'
count(*)
765135
===========================EXPDP============================================
expdp system/passwd directory=dump_dir dumpfile=TT_20151224_%U.dmp logfile=TT_20151224.log schemas=TT job_name=EXPDP_TT_JOB cluster=no parallel=8 compression=all trace=480300
Export: Release 11.2.0.3.0 - Production on Thu Dec 24 09:18:37 2015
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 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYSTEM"."EXPDP_TT_JOB": system/******** directory=dump_dir dumpfile=TT_20151224_%U.dmp logfile=TT_20151224.log schemas=TT job_name=EXPDP_TT_JOB cluster=no parallel=8
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Export> status
Job: EXPDP_TT_JOB
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 8
Job Error Count: 0
Dump File: /app/backup/temp/TT_20151224_01.dmp
bytes written: 4,096
Dump File: /app/backup/temp/TT_20151224_%u.dmp
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: TT
Object Name: TT_208
Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
Completed Objects: 146,000
Worker Parallelism: 1
Export> status
Job: EXPDP_TT_JOB
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 8
Job Error Count: 0
Dump File: /app/backup/temp/TT_20151224_01.dmp
bytes written: 4,096
Dump File: /app/backup/temp/TT_20151224_%u.dmp
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: TT
Object Name: TT_208
Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
Completed Objects: 148,960
Worker Parallelism: 1
Export> status
Job: EXPDP_TT_JOB
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 8
Job Error Count: 0
Dump File: /app/backup/temp/TT_20151224_01.dmp
bytes written: 4,096
Dump File: /app/backup/temp/TT_20151224_%u.dmp
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: TT
Object Name: TT_208
Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
Completed Objects: 152,000
Worker Parallelism: 1
Export> status
Job: EXPDP_TT_JOB
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 8
Job Error Count: 0
Dump File: /app/backup/temp/TT_20151224_01.dmp
bytes written: 4,096
Dump File: /app/backup/temp/TT_20151224_%u.dmp
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: TT
Object Name: TT_302
Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
Completed Objects: 188,000
Worker Parallelism: 1
Export> status
Job: EXPDP_TT_JOB
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 8
Job Error Count: 0
Dump File: /app/backup/temp/TT_20151224_01.dmp
bytes written: 4,096
Dump File: /app/backup/temp/TT_20151224_%u.dmp
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: TT
Object Name: TT_103
Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
Completed Objects: 254,000
Worker Parallelism: 1
Export> status
Job: EXPDP_TT_JOB
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 8
Job Error Count: 0
Dump File: /app/backup/temp/TT_20151224_01.dmp
bytes written: 4,096
Dump File: /app/backup/temp/TT_20151224_%u.dmp
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: TT
Object Name: TT_201
Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
Completed Objects: 256,000
Worker Parallelism: 1
Export>
一直缓慢进行，就算一晚上过去还是这个状态......

=============================TRACE=====================================
System name: AIX
Node name: DB1
Release: 1
Version: 7
Machine:
Instance name: node1
Redo thread mounted by this instance: 1
Oracle process number: 228
Unix process pid: 22676206, image: oracle@DB1 (DM00)
*** 2015-12-24 09:18:43.132
*** SESSION ID:(498.8381) 2015-12-24 09:18:43.132
*** CLIENT ID:() 2015-12-24 09:18:43.132
*** SERVICE NAME:(SYS$USERS) 2015-12-24 09:18:43.132
*** MODULE NAME:(Data Pump Master) 2015-12-24 09:18:43.132
*** ACTION NAME:(EXPDP_TT_JOB) 2015-12-24 09:18:43.132
KUPC: Setting remote flag for this process to FALSE
prvtaqis - Enter
prvtaqis subtab_name upd
prvtaqis sys table upd
KUPP: Initialization complete for master process DM00
*** 2015-12-24 09:18:44.273
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -257656164 lascn 22
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -257656164 lascn 22
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -257656164 lascn 22
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -257656164 lascn 22
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -257656164 lascn 22
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -257656164 lascn 22
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -257656164 lascn 22
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -257656164 lascn 22
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -257656164 lascn 22
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -257656144 lascn 22
*** 2015-12-24 09:18:46.098
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -257656144 lascn 22
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -257656164 lascn 22
*** 2015-12-24 09:18:46.726
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -257654983 lascn 22
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -257656144 lascn 22
*** 2015-12-24 09:30:21.802
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -257656144 lascn 22
kwqberlst !retval block
*** 2015-12-24 09:49:42.929
kwqberlst rqan->lagno_kwqiia 8
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -257656164 lascn 22
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -257656164 lascn 22
*** 2015-12-24 09:49:47.822
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -257656164 lascn 22
*** 2015-12-24 09:50:07.283
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -257656164 lascn 22
*** 2015-12-24 09:50:28.695
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -257656164 lascn 22
*** 2015-12-24 09:54:38.869
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -257656164 lascn 22
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -257656164 lascn 22
*** 2015-12-24 09:54:42.299
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -257656164 lascn 22
*** 2015-12-24 10:03:05.511
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -257656164 lascn 22
*** 2015-12-24 10:03:21.178
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -257656164 lascn 22
*** 2015-12-24 12:19:21.934
kwqberlst rqan->lagno_kwqiia 8
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -257656164 lascn 22
*** 2015-12-24 12:26:42.559
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -257656164 lascn 22
===================================EXP======================================
exp system/passwd file=/app/backup/temp/TT_20151223.dmp log=/app/backup/temp/TT_20151223.log OWNER=TT
导出大小:64G
导出时间:8小时
未能分析出原因所在！

关掉并行有日志显示，搜集table，partition，subpartition信息：
expdp system/passwd directory=dump_dir dumpfile=TT_20151224.dmp logfile=TT_20151224.log schemas=TT job_name=EXPDP_TT_JOB cluster=no trace=480300
Export: Release 11.2.0.3.0 - Production on Thu Dec 24 09:18:37 2015
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 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYSTEM"."EXPDP_TT_JOB": system/******** directory=dump_dir dumpfile=TT_20151224.dmp logfile=TT_20151224.log schemas=TT job_name=EXPDP_TT_JOB cluster=no trace=480300
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Export> status
Job: EXPDP_TT_JOB
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /app/backup/temp/TT_20151224.dmp
bytes written: 4,096
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: TT
Object Name: TT_209
Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
Completed Objects: 160,000
Worker Parallelism: 1
Export> status
Job: EXPDP_TT_JOB
Operation: EXPORT
Mode: SCHEMA
State: EXECUTING
Bytes Processed: 0
Current Parallelism: 1
Job Error Count: 0
Dump File: /app/backup/temp/TT_20151224.dmp
bytes written: 4,096
Worker 1 Status:
Process Name: DW00
State: EXECUTING
Object Schema: TT
Object Name: TT_302
Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA
Completed Objects: 194,000
Worker Parallelism: 1

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORACLE_HOME = /app/oracle/product/11.2.0/db_1
System name: AIX
Node name: DB1
Release: 1
Version: 7
Machine:
Instance name: node1
Redo thread mounted by this instance: 1
Oracle process number: 729
Unix process pid: 9765324, image: oracle@DB1 (DW00)
*** 2015-12-24 14:54:08.646
*** SESSION ID:(2971.10545) 2015-12-24 14:54:08.646
*** CLIENT ID:() 2015-12-24 14:54:08.646
*** SERVICE NAME:(SYS$BACKGROUND) 2015-12-24 14:54:08.646
*** MODULE NAME:() 2015-12-24 14:54:08.646
*** ACTION NAME:() 2015-12-24 14:54:08.646
KUPP:14:54:08.639: Current trace/debug flags: 00480300 = 4719360
*** MODULE NAME:(Data Pump Worker) 2015-12-24 14:54:08.646
*** ACTION NAME:(EXPDP_TT_JOB) 2015-12-24 14:54:08.646
KUPW:14:54:08.646: 0: ALTER SESSION ENABLE PARALLEL DML called.
KUPW:14:54:08.646: 0: ALTER SESSION ENABLE PARALLEL DML returned.
*** 2015-12-24 14:54:08.668
KUPC:14:54:08.668: Setting remote flag for this process to FASSE
prvtaqis - Enter
prvtaqis subtab_name upd
prvtaqis sys table upd
KUPW:14:54:08.758: 0: KUPP$PROC.WHATS_MY_ID called.
KUPW:14:54:08.758: 1: KUPP$PROC.WHATS_MY_ID returned.
KUPW:14:54:08.759: 1: worker max message number: 1000
KUPW:14:54:08.761: 1: Cluster access disabled - all workers and slaves local
KUPW:14:54:08.762: 1: Original job start time: 15-DEC-24 02:54:07 PM
KUPW:14:54:08.765: 1: Seqno 63 is SCHEMA_EXPORT/TABLE/TABLE_DATA
KUPW:14:54:08.765: 1: Seqno 243 is SCHEMA_EXPORT/TABLE/INDEX/TABLE_DATA
KUPW:14:54:08.765: 1: KUPP$PROC.WHATS_MY_NAME called.
KUPW:14:54:08.765: 1: KUPP$PROC.WHATS_MY_NAME returned. Process name: DW00
KUPW:14:54:08.765: 1: KUPV$FT_INT.GET_INSTANCE_ID called.
KUPW:14:54:08.765: 1: KUPV$FT_INT.GET_INSTANCE_ID returned. Instance name: SCDB1:gzsthxzg1
KUPW:14:54:08.767: 1: ALTER SESSION ENABLE RESUMABLE called.
KUPW:14:54:08.768: 1: ALTER SESSION ENABLE RESUMABLE returned.
KUPW:14:54:08.769: 1: KUPF$FILE.INIT called.
KUPW:14:54:08.784: 1: KUPF$FILE.INIT returned.
KUPW:14:54:08.787: 1: KUPF$FILE.GET_MAX_CSWIDTH called.
KUPW:14:54:08.787: 1: KUPF$FILE.GET_MAX_CSWIDTH returned.
KUPW:14:54:08.787: 1: Max character width: 4
KUPW:14:54:08.787: 1: Max clob fetch: 8181
KUPW:14:54:08.787: 1: Max varchar2a size: 8181
KUPW:14:54:08.787: 1: Max varchar2 size: 1990
KUPW:14:54:08.787: 1: In procedure GET_PARAMETERS
KUPW:14:54:08.789: 1: In procedure GET_METADATA_FILTERS
KUPW:14:54:08.790: 1: In procedure GET_METADATA_TRANSFORMS
KUPW:14:54:08.791: 1: In procedure GET_DATA_FILTERS
KUPW:14:54:08.792: 1: In procedure GET_DATA_REMAPS
KUPW:14:54:08.792: 1: In procedure PRINT_MT_PARAMS
KUPW:14:54:08.792: 1: Master table : "SYSTEM"."EXPDP_TT_JOB"
KUPW:14:54:08.792: 1: Metadata job mode : SCHEMA_EXPORT
KUPW:14:54:08.792: 1: Debug enable : TRUE
KUPW:14:54:08.792: 1: Profile enable : FASSE
KUPW:14:54:08.792: 1: Transportable enable : FASSE
KUPW:14:54:08.792: 1: Metrics enable : FASSE
KUPW:14:54:08.793: 1: db version : 11.2.0.3.0
KUPW:14:54:08.793: 1: job version : 11.2.0.0.0
KUPW:14:54:08.793: 1: service name :
KUPW:14:54:08.793: 1: Current Edition : ORA$BASE
KUPW:14:54:08.793: 1: Job Edition :
KUPW:14:54:08.793: 1: Abort Step : 0
KUPW:14:54:08.793: 1: Access Method : AUTOMATIC
KUPW:14:54:08.793: 1: Data Options : 0
KUPW:14:54:08.793: 1: Dumper directory :
KUPW:14:54:08.793: 1: Master only : FASSE
KUPW:14:54:08.793: 1: Data Only : FASSE
KUPW:14:54:08.793: 1: Metadata Only : FASSE
KUPW:14:54:08.793: 1: Estimate : BLOCKS
KUPW:14:54:08.793: 1: Data error logging table :
KUPW:14:54:08.793: 1: Remote Link :
KUPW:14:54:08.793: 1: Dumpfile present : TRUE
KUPW:14:54:08.793: 1: Table Exists Action :
KUPW:14:54:08.793: 1: Partition Options : NONE
KUPW:14:54:08.793: 1: Tablespace Datafile Count: 0
KUPW:14:54:08.793: 1: Metadata Filter Index : 1 Count : 8
KUPW:14:54:08.793: 1: 1 Name - INCLUDE_USER
KUPW:14:54:08.793: 1: Value - TRUE
KUPW:14:54:08.793: 1: Object Name - SCHEMA_EXPORT
KUPW:14:54:08.793: 1: 2 Name - SCHEMA_EXPR
KUPW:14:54:08.793: 1: Value - IN ('TT')
KUPW:14:54:08.793: 1: 3 Name - ORDERED
KUPW:14:54:08.793: 1: Value - FASSE
KUPW:14:54:08.793: 1: Object - TABLE_DATA
KUPW:14:54:08.793: 1: 4 Name - NO_XML
KUPW:14:54:08.793: 1: Value - TRUE
KUPW:14:54:08.793: 1: Object - XMSSCHEMA/EXP_XMSSCHEMA
KUPW:14:54:08.793: 1: 5 Name - XML_OUTOFLINE
KUPW:14:54:08.793: 1: Value - FASSE
KUPW:14:54:08.793: 1: Object - TABLE/TABLE_DATA
KUPW:14:54:08.793: 1: 6 Name - XDB_GENERATED
KUPW:14:54:08.793: 1: Value - FASSE
KUPW:14:54:08.793: 1: Object - TABLE/TRIGGER
KUPW:14:54:08.793: 1: 7 Name - XDB_GENERATED
KUPW:14:54:08.793: 1: Value - FASSE
KUPW:14:54:08.794: 1: Object - TABLE/RSS_POLICY
KUPW:14:54:08.794: 1: 8 Name - PRIVILEGED_USER
KUPW:14:54:08.794: 1: Value - TRUE
KUPW:14:54:08.794: 1: MD remap schema Index : 4 Count : 0
KUPW:14:54:08.794: 1: MD remap other Index : 5 Count : 0
KUPW:14:54:08.794: 1: MD Transform ddl Index : 2 Count : 11
KUPW:14:54:08.794: 1: 1 Name - DBA
KUPW:14:54:08.794: 1: Value - TRUE
KUPW:14:54:08.794: 1: Object - JOB
KUPW:14:54:08.794: 1: 2 Name - EXPORT
KUPW:14:54:08.794: 1: Value - TRUE
KUPW:14:54:08.794: 1: 3 Name - PRETTY
KUPW:14:54:08.794: 1: Value - FASSE
KUPW:14:54:08.794: 1: 4 Name - SQLTERMINATOR
KUPW:14:54:08.794: 1: Value - FASSE
KUPW:14:54:08.794: 1: 5 Name - CONSTRAINTS
KUPW:14:54:08.794: 1: Value - FASSE
KUPW:14:54:08.794: 1: Object - TABLE
KUPW:14:54:08.794: 1: 6 Name - REF_CONSTRAINTS
KUPW:14:54:08.794: 1: Value - FASSE
KUPW:14:54:08.794: 1: Object - TABLE
KUPW:14:54:08.794: 1: 7 Name - OID
KUPW:14:54:08.794: 1: Value - TRUE
KUPW:14:54:08.794: 1: Object - TABLE
KUPW:14:54:08.794: 1: 8 Name - RESET_PARALLEL
KUPW:14:54:08.794: 1: Value - TRUE
KUPW:14:54:08.794: 1: Object - INDEX
KUPW:14:54:08.794: 1: 9 Name - OID
KUPW:14:54:08.794: 1: Value - TRUE
KUPW:14:54:08.794: 1: Object - TYPE
KUPW:14:54:08.794: 1: 10 Name - OID
KUPW:14:54:08.794: 1: Value - TRUE
KUPW:14:54:08.794: 1: Object - INC_TYPE
KUPW:14:54:08.794: 1: 11 Name - REVOKE_FROM
KUPW:14:54:08.794: 1: Value - SYSTEM
KUPW:14:54:08.795: 1: Object - ROLE

一直就处在这个阶段，很慢很慢！

node1_dm00_7995838.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORACLE_HOME = /app/oracle/product/11.2.0/db_1
System name: AIX
Node name: DB1
Release: 1
Version: 7
Machine:
Instance name: node1
Redo thread mounted by this instance: 1
Oracle process number: 725
Unix process pid: 7995838, image: oracle@SB1 (DM00)
*** 2015-12-24 14:54:06.995
*** SESSION ID:(2481.4441) 2015-12-24 14:54:06.995
*** CLIENT ID:() 2015-12-24 14:54:06.995
*** SERVICE NAME:(SYS$USERS) 2015-12-24 14:54:06.995
*** MODULE NAME:() 2015-12-24 14:54:06.995
*** ACTION NAME:() 2015-12-24 14:54:06.995
KUPP:14:54:06.987: Current trace/debug flags: 00480300 = 4719360
*** MODULE NAME:(Data Pump Master) 2015-12-24 14:54:07.015
*** ACTION NAME:(EXPDP_TT_JOB) 2015-12-24 14:54:07.015
KUPC:14:54:07.015: Setting remote flag for this process to FALSE
prvtaqis - Enter
prvtaqis subtab_name upd
prvtaqis sys table upd
KUPM:14:54:07.071: Attached to control queue as MCP
KUPM:14:54:07.072: While starting, control queue subscriber count is: 2
KUPP:14:54:07.072: Initialization complete for master process DM00
KUPM:14:54:07.087: Entered main loop
KUPM:14:54:07.096: ****IN DISPATCH at 53647, request type=1001
KUPM:14:54:07.096: Current user is: SYSTEM
KUPM:14:54:07.096: hand := DBMS_DATAPUMP.OPEN ('EXPORT', 'SCHEMA', '', 'EXPDP_TT_JOB', '', '2');
KUPM:14:54:07.211: Resumable enabled
KUPM:14:54:07.218: Entered state: DEFINING
KUPM:14:54:07.218: initing file system
KUPM:14:54:07.236: ****OUT DISPATCH, request type=1001, response type =2041
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -249373909 lascn 22
KUPM:14:54:07.269: ****IN DISPATCH at 53647, request type=1035
KUPM:14:54:07.269: Current user is: SYSTEM
KUPM:14:54:07.269: DBMS_DATAPUMP.SET_PARAMETER (hand, 'TRACE', 4719360);
KUPM:14:54:07.269: In Check_param_dependency with name: TRACE
KUPM:14:54:07.271: ****OUT DISPATCH, request type=1035, response type =2041
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -249373909 lascn 22
KUPM:14:54:07.353: ****IN DISPATCH at 53647, request type=1022
KUPM:14:54:07.353: Current user is: SYSTEM
KUPM:14:54:07.353: DBMS_DATAPUMP.ADD_FILE (hand, 'TT_20151224.log', 'DUMP_DIR', 0, , 3);
KUPM:14:54:07.358: ****OUT DISPATCH, request type=1022, response type =2041
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -249373909 lascn 22
KUPM:14:54:07.374: ****IN DISPATCH at 53647, request type=1012
KUPM:14:54:07.375: Current user is: SYSTEM
KUPM:14:54:07.375: DBMS_DATAPUMP.LOG_ENTRY (hand, ';;;
Export: Release 11.2.0.3.0 - Production on Thu Dec 24 14:54:03 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
', 1);
KUPM:14:54:07.375: Log message received from shadow:
KUPM:14:54:07.375: RQ,KUPC$C_1_20
15122414540
6,KUPC$A_1_145406787940000,MCP,4,Y
KUPM:14:54:07.375: ;;;
Export: Release 11.2.0.3.0 - Production on Thu Dec 24 14:54:03 2015
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
KUPM:14:54:07.375: ****OUT DISPATCH, request type=1012, response type =2041
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -249373909 lascn 22
KUPM:14:54:07.390: ****IN DISPATCH at 53647, request type=1012
KUPM:14:54:07.390: Current user is: SYSTEM
KUPM:14:54:07.390: DBMS_DATAPUMP.LOG_ENTRY (hand, ';;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Applicati
KUPM:14:54:07.391: on Testing options', 1);
KUPM:14:54:07.391: Log message received from shadow:
KUPM:14:54:07.391: RQ,KUPC$C_1_20
15122414540
6,KUPC$A_1_145406787940000,MCP,5,Y
KUPM:14:54:07.391: ;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
KUPM:14:54:07.391: ****OUT DISPATCH, request type=1012, response type =2041
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -249373909 lascn 22
KUPM:14:54:07.407: ****IN DISPATCH at 53647, request type=1035
KUPM:14:54:07.407: Current user is: SYSTEM

KUPM:14:54:07.407: DBMS_DATAPUMP.SET_PARAMETER (hand, 'COMMAND_LINE_CLIENT', 1);
KUPM:14:54:07.407: In Check_param_dependency with name: COMMAND_LINE_CLIENT
KUPM:14:54:07.408: ****OUT DISPATCH, request type=1035, response type =2041
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -249373909 lascn 22
KUPM:14:54:07.424: ****IN DISPATCH at 53647, request type=1035
KUPM:14:54:07.424: Current user is: SYSTEM
KUPM:14:54:07.424: DBMS_DATAPUMP.SET_PARAMETER (hand, 'CLIENT_COMMAND', 'system/******** directory=dump_dir dumpfile=TT_20151224.dmp
logfile=TT_20151224.log schemas=TT job_name=EXPDP_TT_JOB cluster=no trace=480300 ');
KUPM:14:54:07.424: In Check_param_dependency with name: CLIENT_COMMAND
KUPM:14:54:07.426: ****OUT DISPATCH, request type=1035, response type =2041
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -249373909 lascn 22
KUPM:14:54:07.446: ****IN DISPATCH at 53647, request type=1032
KUPM:14:54:07.446: Current user is: SYSTEM
KUPM:14:54:07.446: In metadata filter....
KUPM:14:54:07.446: DBMS_DATAPUMP.METADATA_FILTER (hand, 'SCHEMA_LIST', ''TT'', '');
KUPM:14:54:07.466: ****OUT DISPATCH, request type=1032, response type =2041
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -249373909 lascn 22
KUPM:14:54:07.496: ****IN DISPATCH at 53647, request type=1022
KUPM:14:54:07.496: Current user is: SYSTEM
KUPM:14:54:07.496: DBMS_DATAPUMP.ADD_FILE (hand, 'TT_20151224.dmp', 'DUMP_DIR', 0, , 1);
KUPM:14:54:07.608: ****OUT DISPATCH, request type=1022, response type =2041
kwqberlst !retval block
kwqberlst rqan->lagno_kwqiia 8
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 8
kwqberlst ascn -249373909 lascn 22
KUPM:14:54:07.627: ****IN DISPATCH at 53647, request type=1003
KUPM:14:54:07.627: Current user is: SYSTEM
KUPM:14:54:07.627: DBMS_DATAPUMP.START_JOB (hand, 0, 0, , 0);
KUPM:14:54:07.630: ...defaulting parameter ESTIMATE
KUPM:14:54:07.631: ...defaulting parameter COMPRESSION
KUPM:14:54:07.633: ...defaulting parameter DATA_ACCESS_METHOD
KUPM:14:54:07.633: ...defaulting parameter DATA_OPTIONS
KUPM:14:54:07.634: ...defaulting parameter INCLUDE_METADATA
KUPM:14:54:07.634: ...defaulting parameter KEEP_MASTER
KUPM:14:54:07.634: ...defaulting parameter MASTER_ONLY
KUPM:14:54:07.634: ...defaulting parameter METRICS
KUPM:14:54:07.635: ...defaulting parameter REUSE_DATAFILES
KUPM:14:54:07.635: ...defaulting parameter SKIP_UNUSABLE_INDEXES
KUPM:14:54:07.635: ...defaulting parameter STREAMS_CONFIGURATION
KUPM:14:54:07.635: ...defaulting parameter TABLE_CONSISTENCY
KUPM:14:54:07.636: ...defaulting parameter TABLE_EXISTS_ACTION
KUPM:14:54:07.636: ...defaulting parameter TTS_FULL_CHECK
KUPM:14:54:07.636: ...defaulting parameter USER_METADATA
*** 2015-12-24 14:54:07.668
KUPM:14:54:07.668: Log message received from MCP
KUPM:14:54:07.668: FLASHBACK automatically enabled to preserve database integrity.
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 7
kwqberlst ascn -249373885 lascn 22
KUPM:14:54:07.671: Safe SCN asserted on start with cookie: S:8:GZSTHXZG:
KUPM:14:54:08.072: Stmt to load DATAPUMP_PATHS is: INSERT INTO "SYSTEM"."EXPDP_TT_JOB" (process_order, duplicate, object_path_se
qno, object_type_path, object_name) SELECT :1, ROWNUM, seq_num, full_path, object_path FROM SYS.DATAPUMP_PATHS WHERE HET_TYPE =
KUPM:14:54:08.072: :2
KUPM:14:54:08.280: Stmt to load DATAPUMP_PATHMAP is: INSERT INTO "SYSTEM"."EXPDP_TT_JOB" (process_order, duplicate, object_path_
seqno, object_name) SELECT :1, ROWNUM, seq_num, het_type FROM (SELECT p.seq_num seq_num, m.het_type het_type FROM DATAPUMP_PATHMAP
KUPM:14:54:08.280: m, SYS.DATAPUMP_PATHS p WHERE m.object_path = p.full_path AND p.object_path = p.full_path AND p.het_type = :2)
KUPM:14:54:08.442: In BUILD_MTABLE_INDEXES
KUPM:14:54:08.505: Trying to create master table index: CREATE INDEX SYS_MTABLE_00028EDEF_IND_1 ON "SYSTEM"."EXPDP_TT_JOB" (obje
ct_schema, object_name, object_type)
KUPM:14:54:08.529: Trying to create master table index: CREATE INDEX SYS_MTABLE_00028EDEF_IND_2 ON "SYSTEM"."EXPDP_TT_JOB" (base
_process_order)
KUPM:14:54:08.543: Indexes have been built.
KUPM:14:54:08.555: Entered state: EXECUTING
KUPM:14:54:08.555: Log message received from MCP
KUPM:14:54:08.555: Starting "SYSTEM"."EXPDP_TT_JOB": system/******** directory=dump_dir dumpfile=TT_20151224.dmp logfile=TT_201
51224.log schemas=TT job_name=EXPDP_TT_JOB cluster=no trace=480300
kwqberlst rqan->lascn_kwqiia > 0 block
kwqberlst rqan->lascn_kwqiia 7

8楼补充：
KUPW:14:54:08.795: 1: Data Filter Index : 6 Count : 0
KUPW:14:54:08.795: 1: Data Remap Index : 7 Count : 0
KUPW:14:54:08.795: 1: MD remap name Index : 8 Count : 0
KUPW:14:54:08.795: 1: In procedure DISPATCH_WORK_ITEMS
KUPW:14:54:08.796: 1: In procedure SEND_MSG. Fatal=0
KUPW:14:54:08.796: 1: KUPC$QUEUE.TRANSCEIVE called.
kwqberSSt !retval block
kwqberSSt rqan->lagno_kwqiia 8
kwqberSSt rqan->lascn_kwqiia > 0 block
kwqberSSt rqan->lascn_kwqiia 8
kwqberSSt ascn -249373820 lascn 22
kwqberSSt !retval block
kwqberSSt rqan->lagno_kwqiia 8
KUPW:14:54:08.807: 1: KUPC$QUEUE.TRANSCEIVE returned. Received 2011
KUPW:14:54:08.807: 1: DBMS_LOB.CREATETEMPORARY called.
KUPW:14:54:08.807: 1: DBMS_LOB.CREATETEMPORARY returned.
KUPW:14:54:08.809: 1: Flags: 18
KUPW:14:54:08.809: 1: Start sequence number:
KUPW:14:54:08.809: 1: End sequence number:
KUPW:14:54:08.809: 1: Metadata Parallel: 1
KUPW:14:54:08.809: 1: Primary worker id: 1
KUPW:14:54:08.811: 1: In procedure GET_TABLE_DATA_OBJECTS
KUPW:14:54:08.811: 1: In procedure CREATE_MSG
KUPW:14:54:08.811: 1: KUPV$FT.MESSAGE_TEXT called.
KUPW:14:54:08.811: 1: KUPV$FT.MESSAGE_TEXT returned.
KUPW:14:54:08.811: 1: In procedure SEND_MSG. Fatal=0
KUPW:14:54:08.812: 1: KUPC$QUEUE_INT.SEND called.
kwqberSSt !retval block
kwqberSSt rqan->lagno_kwqiia 8
kwqberSSt rqan->lascn_kwqiia > 0 block
kwqberSSt rqan->lascn_kwqiia 8
kwqberSSt ascn -249373820 lascn 22
kwqberSSt !retval block
kwqberSSt rqan->lagno_kwqiia 8
KUPW:14:54:08.813: 1: KUPC$QUEUE_INT.SEND returned.
KUPW:14:54:08.813: 1: Estimate in progress using BLOCKS method...
KUPW:14:54:08.814: 1: In procedure CONFIGURE_METADATA_UNLOAD
KUPW:14:54:08.814: 1: Phase: ESTIMATE_PHASE Filter Name: Filter Value:
KUPW:14:54:08.814: 1: DBMS_METADATA.OPEN11.2.0.0.0 called.
KUPW:14:54:09.358: 1: DBMS_METADATA.OPEN11.2.0.0.0 returned. Source handle: 100001
KUPW:14:54:09.358: 1: DBMS_METADATA.SET_FILTER called. metadata_phase: ESTIMATE_PHASE
KUPW:14:54:09.358: 1: DBMS_METADATA.SET_FILTER returned. In function GET_NOEXP_TABLE
KUPW:14:54:09.365: 1: DBMS_METADATA.SET_PARSE_ITEM called.
KUPW:14:54:09.565: 1: DBMS_METADATA.SET_PARSE_ITEM returned.
KUPW:14:54:09.565: 1: DBMS_METADATA.SET_COUNT called.
KUPW:14:54:09.569: 1: DBMS_METADATA.SET_COUNT returned.
KUPW:14:54:09.569: 1: In FETCH_XML_OBJECTS
KUPW:14:54:09.569: 1: KUPF$FILE.OPEN_CONTEXT called.
KUPW:14:54:09.570: 1: KUPF$FILE.OPEN_CONTEXT returned.
KUPW:14:54:09.570: 1: DBMS_METADATA.FETCH_XML_CLOB called. Handle: 100001
*** 2015-12-24 15:05:12.055
KUPW:15:05:12.054: 1: DBMS_METADATA.FETCH_XML_CLOB returned.
KUPW:15:05:12.055: 1: Object seqno fetched: 63
KUPW:15:05:12.055: 1: Object path fetched: SCHEMA_EXPORT/TABLE/TABLE_DATA
KUPW:15:05:12.055: 1: In procedure COMPLETE_EXP_OBJECT
KUPW:15:05:12.055: 1: KUPF$FILE.FLUSH_LOB called.
KUPW:15:05:12.055: 1: KUPF$FILE.FLUSH_LOB returned.
KUPW:15:05:12.055: 1: In procedure UPDATE_TYPE_COMPLETION_ROW
KUPW:15:05:12.055: 1: Old Seqno: 0 New Path: SCHEMA_EXPORT/TABLE/TABLE_DATA PO Num: -5 New Seqno: 63
KUPW:15:05:12.059: 1: Created type completion for duplicate 63
KUPW:15:05:12.059: 1: In procedure CREATE_MSG
KUPW:15:05:12.059: 1: KUPV$FT.MESSAGE_TEXT called.
KUPW:15:05:12.059: 1: KUPV$FT.MESSAGE_TEXT returned.
KUPW:15:05:12.059: 1: In procedure SEND_MSG. Fatal=0
KUPW:15:05:12.059: 1: KUPC$QUEUE_INT.SEND called.
kwqberSSt !retval block
kwqberSSt rqan->lagno_kwqiia 8
kwqberSSt rqan->lascn_kwqiia > 0 block
kwqberSSt rqan->lascn_kwqiia 8
kwqberSSt ascn -249373820 lascn 22
kwqberSSt !retval block
kwqberSSt rqan->lagno_kwqiia 8
KUPW:15:05:12.062: 1: KUPC$QUEUE_INT.SEND returned.
KUPW:15:05:12.062: 1: Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
KUPW:15:05:12.066: 1: In procedure CREATE_TABLE_DATA_OBJECT_ROWS
KUPW:15:05:12.066: 1: In function GATHER_PARSE_ITEMS
KUPW:15:05:12.066: 1: In function CHECK_FOR_REMAP_NETWORK
KUPW:15:05:12.066: 1: Nothing to remap
KUPW:15:05:12.066: 1: In procedure BUILD_OBJECT_STRINGS
KUPW:15:05:12.066: 1: In DETERMINE_BASE_OBJECT_INFO
KUPW:15:05:12.066: 1: TABLE_DATA
KUPW:15:05:12.066: 1: TT
KUPW:15:05:12.066: 1: TT_T1
KUPW:15:05:12.066: 1:
KUPW:15:05:12.066: 1:
KUPW:15:05:12.066: 1: TABLE
KUPW:15:05:12.066: 1: TT
KUPW:15:05:12.066: 1: TT_T1
KUPW:15:05:12.076: 1: In procedure LOCATE_DATA_FILTERS
KUPW:15:05:12.076: 1: In function NEXT_PO_NUMBER
KUPW:15:05:12.095: 1: In function GATHER_PARSE_ITEMS
KUPW:15:05:12.095: 1: In function CHECK_FOR_REMAP_NETWORK
KUPW:15:05:12.095: 1: Nothing to remap
KUPW:15:05:12.095: 1: In procedure BUILD_OBJECT_STRINGS
KUPW:15:05:12.095: 1: In DETERMINE_BASE_OBJECT_INFO
KUPW:15:05:12.095: 1: TABLE_DATA
............