oracle expdp导出慢,expdp导出慢的解决思路__增加参数metrics记录每个步骤时间,增加参数trace记录trace...

两者都是未公开的参数expdp -help看不到

expdp system/xxx directory=DATADIR dumpfile=data1.dmp logfile=log1.log schemas=hr CONTENT=METADATA_ONLY INCLUDE=TABLE:\"IN\(\'SCANLOG\'\)\"

METRICS=Y TRACE=480300

Majority of issues use following two data pump parameters:

METRICS=Y -- this will provide timing data on number of objects

TRACE=480300 -- this will trace dm and dw processes

开启了METRICS=Y的话，导出日志记录了每个对象的导出时间

没有加METRICS=Y的情况下

，D20181029_01.log日志信息

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Starting "SYSTEM"."SYS_EXPORT_SCHEMA_03":  system/******** directory=DATA_PUMP_DIR dumpfile=D20181029_01 logfile=D20181029_01.log schemas=HR CONTENT=METADATA_ONLY METRICS=Y TRACE=480300 INCLUDE=TABLE:"IN('APPROVELOG')"

Processing object type SCHEMA_EXPORT/TABLE/TABLE

Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT

加了METRICS=Y的情况下

，D20181029_02.log日志信息

Connected to: Oracle Database 11g Ent