RE: how to improve impdp

From: Iotzov, Iordan <IIotzov_at_newsamerica.com>
Date: Tue, 9 Jul 2013 11:00:39 -0400
Message-ID: <9287D00721407A4CBDC9925C789DBB6702CEB38491_at_nam-wil-exc-l03.newsamerica.com>



If impdp over DB link approach is not feasible and IO throughput to/from the export/import files is not an issue, you might try "overlapping" the export and the import. You can split the 4 hour export into a number of smaller exports. Run the first small export and upon completion concurrently start the corresponding small import and the next small export. After the next small export is done, start the next small export and run (or queue) the corresponding small import, and so on.

To be done safely, this approach requires knowledge of schemas, tables and constraints in the underlying database. Thorough testing is a must - make sure that ALL objects are accounted for.

Iordan Iotzov
http://iiotzov.wordpress.com/

Check out SmartSource Xpress, our new iPad app! Follow us on Twitter | Like us on Facebook

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hsieh, Joan Sent: Tuesday, July 09, 2013 10:15 AM
To: oracle_l
Subject: how to improve impdp

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

This message and its attachments may contain legally privileged or confidential information. It is intended solely for the named addressee. If you are not the addressee indicated in this message (or responsible for delivery of the message to the addressee), you may not copy or deliver this message or its attachments to anyone. Rather, you should permanently delete this message and its attachments and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of News America Incorporated or its subsidiaries must be taken not to have been sent or endorsed by any of them. No warranty is made that the e-mail or attachment(s) are free from computer virus or other defect.

--

http://www.freelists.org/webpage/oracle-l Received on Tue Jul 09 2013 - 17:00:39 CEST

Original text of this message