Re: ImpDp performance

From: sumit Tyagi <dba.tyagisumit_at_gmail.com>
Date: Thu, 14 May 2015 07:21:45 +0530
Message-ID: <CAFW4NVxc=4iMrmFG9_jm2yYkkb--PGiu6Zp8NYzPdrf=s1VBdQ_at_mail.gmail.com>

Thank You all for the suggestions . I did some more investigation and found some below useful docs on oracle metalink:

Performance Problems When Transferring LOBs Using IMPDP With NETWORK_LINK (Doc ID 1488229.1)
"In What Order Are Indexes Built During Datapump Import (IMPDP) and How to Optimize the Index Creation (Doc ID 1966442.1)" DataPump Import Does Not Use Multiple Parallel PX Processes For Index Creation (Doc ID 1081069.1) .
What DataPump And Oracle RDBMS Parameters Can Significantly Affect DataPump Performance ? (Doc ID 1611373.1)
Checklist For Slow Performance Of DataPump Export (expdp) And Import (impdp) (Doc ID 453895.1)
http://oracle-randolf.blogspot.com/2011/02/concurrent-index-creation.html

BR
Sumit

On Wed, May 13, 2015 at 10:39 PM, Andrew Kerber <andrew.kerber_at_gmail.com> wrote:

> ??? That option has to do with whether or not you import stats with the
> table, not gathering stats.
>
> Sent from my iPad
>
> On May 13, 2015, at 10:58 AM, Stephens, Chris <Chris.Stephens_at_adm.com>
> wrote:
>
> I don’t think (as of 11G) datapump has the ability to collect statistics
> in parallel. Better to collect outside of import job.
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [
> mailto:oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org>] *On
> Behalf Of *Andrew Kerber
> *Sent:* Wednesday, May 13, 2015 9:49 AM
> *To:* sumit Tyagi
> *Cc:* Oracle L
> *Subject:* Re: ImpDp performance
>
>
>
> That won't really gain you any time. Regardless you will want to gather
> stats on the new system.
>
> Sent from my iPhone
>
>
> On May 13, 2015, at 9:02 AM, sumit Tyagi <dba.tyagisumit_at_gmail.com> wrote:
>
> Thanks will look into it ... And what about exclude=statistics
>
> On 13 May 2015 18:09, "Andrew Kerber" <andrew.kerber_at_gmail.com> wrote:
>
> Those all will help. The advantage from nologging is minimal if your redo
> logs are adequately sized.
>
> Sent from my iPad
>
> > On May 13, 2015, at 3:20 AM, sumit Tyagi <dba.tyagisumit_at_gmail.com>
> wrote:
> >
> >
> > Hi oracle-L Team ,
> >
> > One of our client has suggested the below to improve the impdp
> performance . Please suggest on same , Can this help in performance
> improvement of impdp . I have checked there are several restrictions
> > on network_link usage .
> >
> > 1. Use network_link with impdp instead of export/copy/import
> > 2. Replace tables but exclude indexes and constraints
> > 3 Use indexfile to generate the index/constraint creation script and
> Write a script that will:
> >
> > o Create the indexes in parallel (not the parallel=X option but launch
> multiple create indexes simultaneously since we are on standard edition)
> > o Increase the sort_area_size for the session before creating the indexes
> > o Change the constraint create to use novalidate
> > o Create the indexes with nologging.
> >
> >
> > --
> >
> > --
> > BR
> > Sumit
>
>
>
> CONFIDENTIALITY NOTICE:
> This message is intended for the use of the individual or entity to which
> it is addressed and may contain information that is privileged,
> confidential and exempt from disclosure under applicable law. If the reader
> of this message is not the intended recipient or the employee or agent
> responsible for delivering this message to the intended recipient, you are
> hereby notified that any dissemination, distribution or copying of this
> communication is strictly prohibited. If you have received this
> communication in error, please notify us immediately by email reply.
>
>
>

-- 

*--*
*BR*
*Sumit Tyagi*
*+91-7829543355*

--
http://www.freelists.org/webpage/oracle-l

Received on Thu May 14 2015 - 03:51:45 CEST