??? 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@xxxxxxx> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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@xxxxxxxxx> wrote:
Thanks will look into it ... And what about exclude=statistics
On 13 May 2015 18:09, "Andrew Kerber" <andrew.kerber@xxxxxxxxx> 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@xxxxxxxxx> 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.
