Home » RDBMS Server » Performance Tuning » datapump parallel
datapump parallel [message #197213] Tue, 10 October 2006 09:14 Go to next message
cmerrill@concordefs.com
Messages: 2
Registered: October 2006
Location: Memphis
Junior Member
Hi all,


I have a large partitioned table that I exported using expdp. for the export I used the %U wildcard to export the partitions. Each partition is about 6.5 Gig. The export was very fast, about 2 minutes each.

I had to drop the table and rebuild it on a new partition key. While using the impdp along with parallel I am seeing only one worker doing all of the work. I have tried several different levels of the parallel option.

The data in the dumpfiles should span multiple partitions. A majority of it would be in 4 partitions .

This was in 10.1.0.4

Any help/suggestions would be apprecited.

Thanks
Chris

[Updated on: Tue, 10 October 2006 12:30]

Report message to a moderator

Re: datapump parallel [message #198498 is a reply to message #197213] Tue, 17 October 2006 07:10 Go to previous message
kimant
Messages: 201
Registered: August 2006
Location: Denmark
Senior Member
Have You checked that You actually have the parallel option?

Standard Edition does not have this.

Br
Kim
Previous Topic: Fine Tuning This query
Next Topic: Spool from DB table to flat file slow
Goto Forum:
  


Current Time: Thu Dec 08 22:15:47 CST 2016

Total time taken to generate the page: 0.08028 seconds