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!

impdp too slow

636304May 29 2009 — edited May 29 2009

I exported data using:

expdp system/***@*** directory=dp_t24 dumpfile=t24_%U.dmp schemas=t24 exlude=views,statustics parallel=8

Export has been done in IBM P5 Server with AIX 5.3 and Oracle 10.2.0.3
Database size is 500 gb
and dump size 161 gb
Expdp took 6 hours

I am importing:

impdp system/****@*** directory=dp_t24 dumpfile=t24_%U.dmp schemas=t24 parallel=8

Import has been taken 24 hours but still not completed.
This is 8-core CPU machine wit RAM 32GB. But cpu parallelism is not working.
ANy suggesiton?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 26 2009

Added on May 29 2009

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

4 comments

4,926 views