Re: 11gR2 Data Pump question - parallel setting
- From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
- To: JC1706@xxxxxxx
- Date: Thu, 26 Jul 2012 16:37:21 -0700
The parallel setting has the most positive impact when the object has *not*
be pre-created. That said, it mostly just changes the number of workers
doing the data import, I'm pretty certain (but not 100%) that it will not
help index creation, constraints etc. to run faster because it simply runs
the DDL (so it wont be any more "parallel" than the setting inside the
source db). If you want those things to go faster, run them outside DP as
it's just metadata (DDL) anyway inside the DP file.
On Thu, Jul 26, 2012 at 3:14 PM, CRISLER, JON A <JC1706@xxxxxxx> wrote:
> Is there any benefit to setting a Data Pump import to parallel=12 if the
> export was run with parallel=8 ? It seems to accept higher values, and
> spawns 12 workers. My goal is to get the items like index creation,
> constraints etc. to run faster. The source system has 8 cpu's, the target
> system 24 cpus.
>
--
Regards,
Greg Rahn | blog <http://bit.ly/u9N0i8> | twitter <http://bit.ly/v733dJ> |
linkedin <http://linkd.in/gregrahn>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
