Oracle Data Pump Performance Tuning

Commands used

expdp username/password directory=dump_dir dumpfile=full.dmp logfile=full.log full=y parallel=16

impdp username/password directory=dump_dir dumpfile=full.dmp logfile=full.log parallel=16

During the test we noticed that expdp took 13 minutes and impdp took 45 minutes

using export in parallel to multiple files has significantly reduced the time

expdp username/password directory=dump_dir filesize=1G dumpfile=full%U.dmp logfile=fulllog parallel=16

impdp username/password directory=dump_dir dumpfile=full%U.dmp logfile=full.log parallel=16

We noticed expdp took 2 minutes now and impdp took same 45 minutes.

After increasing pga_aggregate_target to 6 GB, performance of import came down to 14 minutes.