Datapump Export of DDL is extremely slow on On-PREM
Summary:
Datapump Export of DDL is extremely slow on On-PREM
Content (required):
Source Database size : 4.5 TB
Platform: AIX
DB Version : 12.2.0.4
For Migration purpose, we are taking DDL backup using the below command and its taking 12+ hours
expdp \'/as sysdba\' directory=OCIEXP dumpfile=expdp_TST_FULL_DDL_%U.dmp logfile=expdp_TST_FULL_DDL.log FULL=Y CONTENT=METADATA_ONLY PARALLEL=4 EXCLUDE=STATISTICS EXCLUDE=TABLE_STATISTICS,INDEX_STATISTICS EXCLUDE=AUDIT_TRAILS
We tried Gathering STATS and Fixed object STATS but still its taking a long time to complete.
Could you please suggest any workaround to reduce the export backup timing?
Tagged:
1