Re: 11gR2 Data Pump question - parallel setting
From: Greg Rahn <greg_at_structureddata.org>
Date: Thu, 26 Jul 2012 16:37:21 -0700
Message-ID: <CAGXkmivWxWsf3mk7QWeoZDFTCsHHQvxaJHodPti1eqqQSnj-_Q_at_mail.gmail.com>
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.
Date: Thu, 26 Jul 2012 16:37:21 -0700
Message-ID: <CAGXkmivWxWsf3mk7QWeoZDFTCsHHQvxaJHodPti1eqqQSnj-_Q_at_mail.gmail.com>
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_at_att.com> 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> -- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 26 2012 - 18:37:21 CDT