Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DATAPUMP with NETWORK_LINK slower than expected

plhtyukNov 25 2011 — edited Nov 29 2011

Hi everyone,

On a dedicated Oracle machine 11GR2 (I am alone on that test server) I did the following test with DATAPUMP:

1- Export the USER A into a dump file
2- Import the dump file into USER B
3- Drop and recreate user B
4- Import the data from USER A into USER B using the NETWORK_LINK parameter.

N.B. Both user A and B resides on the same Oracle instance/database so the database link point to "itself".

1- Took approx. 4 minutes.
2- Took approx. 10 minutes.
4- Took approx. 13 minutes.

To summarize :

It took approx. 14 minutes to copy the data from user A to user B with datapump using a DUMP file (classical method).
It took approx. 13 minutes to copy the data from user A to user B using a NETWORK_LINK.

We earned approx. only 1 minutes using the NETWORK_LINK method compared to the classical method but we expected more than that. It should inccur less I/O to use the NETWORK_LINK method...

Are you agree with me?

Best regards.

Carl

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 27 2011

Added on Nov 25 2011

#11gr2, #database-key-features, #export-import-sql-loader-external-tables, #performance

8 comments

1,472 views