Re: ImpDp performance

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Wed, 13 May 2015 12:09:03 -0500
Message-Id: <06871582-F140-4155-988A-A1EB3F3FA59B_at_gmail.com>

??? 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] 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.
>
>

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

Received on Wed May 13 2015 - 19:09:03 CEST