how to improve impdp

From: Hsieh, Joan <Joan.Hsieh_at_tufts.edu>
Date: Tue, 9 Jul 2013 14:14:56 +0000
Message-ID: <416FB269D9362D4AA40BE7124CA3EF9F0AB9267C_at_SSVMEXDAG01MB02.tufts.ad.tufts.edu>

Hi List,
I'm trying to use data pump to export and import from the AIX database to the LINUX database. The application is peoplesoft Finacial. The expdp take around 4 hours, the impdp take 7 hours which is a big concern on the weekend production cutover time.

The parameter I used on the impdp as below, do you have any suggestion how to improve the impdp time?

Thanks,

Joan

userid= /
directory=dmpdir
dumpfile=FMPROD_expdp.1300_070213.dmp
PARALLEL=5
logfile=impdp_FINPROD1_i07032013114001.log

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jul 09 2013 - 16:14:56 CEST