Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Exclude=statistics with IMPDP

JhilAug 20 2015 — edited Aug 21 2015

Hello all ;

After import , using  DBMS package we are gathering statistics.

To reduce import time , can we set always exclude=statistics  with IMPDP  ?

SQL> show parameter _optimizer_compute_index_stats;

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

_optimizer_compute_index_stats       boolean     TRUE



>> To avoid  index level statistics  at that  time of import ,


      Is it recommended to  set    _optimizer_compute_index_stats= false  ?

Thanks.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 18 2015
Added on Aug 20 2015
3 comments
4,372 views