Re: datapump export incredibly slow
From: Jinwen Zou <zjworacle_at_gmail.com>
Date: Mon, 17 Feb 2014 16:18:43 +1100
Message-ID: <CAOEQsPL2XyvmeymrK07jj-jU1HVbcxVsnSsox+pXtF-swcS_Kg_at_mail.gmail.com>
I believe what Raj mean to to say is that: sometimes ACCESS_METHOD=external_table export is better than direct path export for table/partition that has out-of-line stored LOBs or many chained rows, because direct path export will not use more than 1 PX process for a single segment, but external_table export will. Agreed.
Date: Mon, 17 Feb 2014 16:18:43 +1100
Message-ID: <CAOEQsPL2XyvmeymrK07jj-jU1HVbcxVsnSsox+pXtF-swcS_Kg_at_mail.gmail.com>
I believe what Raj mean to to say is that: sometimes ACCESS_METHOD=external_table export is better than direct path export for table/partition that has out-of-line stored LOBs or many chained rows, because direct path export will not use more than 1 PX process for a single segment, but external_table export will. Agreed.
Per note 552424.1, the external_table path impdp can't import LOB in parallel in 11g or lower.
On Mon, Feb 17, 2014 at 12:35 PM, rjamya <rjamya_at_gmail.com> wrote:
> And remember, if you are exporting CLOBs, then you are out of luck :)
> Sometimes you will get better performance with ACCESS_METHOD=external_table
> but that you have to try out. Also if flashback_time is not critical for
> you, I'd take it out.
>
> Raj
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Feb 17 2014 - 06:18:43 CET