Re: Paralelize CONSTRAINT VALIDATION during impdp
From: <noreply_at_maillard.im>
Date: Mon, 05 Aug 2013 22:56:10 +0200
Message-ID: <m04nb3eu1h.fsf_at_kcals.intra.maillard.im>
Mladen Gogala <gogala.mladen_at_gmail.com> writes:
Date: Mon, 05 Aug 2013 22:56:10 +0200
Message-ID: <m04nb3eu1h.fsf_at_kcals.intra.maillard.im>
Mladen Gogala <gogala.mladen_at_gmail.com> writes:
> On Mon, 05 Aug 2013 00:00:55 +0200, noreply wrote:
>
>> Is it normal that with IMPDP PARALLEL=8, the CONSTRAINT VALIDATION step
>> is not taking advantage of the PARALLEL parameter ?
>
> Yes. Constraint validation step, to the best of my knowledge, doesn't use
> parallelism. Never has. What kind of constraint is the problem? You can
> create constraints separately from the import using a SQL script and then
> use "NOVALIDATE" clause for the big tables. It's a bit more of the DBA
> time, but the import will get completed sooner.
I do not have the exact numbers but what is sure is that the data loading is just the quickest step and takes less than 1h30. The IMPDP total time is more than 7 hours !
Thank you for your suggestion.
-- XMAReceived on Mon Aug 05 2013 - 22:56:10 CEST