Re: impdp performance in 11.1 vs 11.2

You may be thinking of an older version. This is from an 11.2 Oracle white paper.

*During export, when there are two or more worker processes, data and metadata unloading proceed in parallel. Data Pump will also automatically build each index in parallel up to the degree of parallelism of the job. The permanent parallel degree of the index itself remains unchanged from its source value. *
http://download.oracle.com/otndocs/products/database/enterprise_edition/utilities/pdf/datapump11gr2_techover_1009.pdf

Seth Miller

On Wednesday, August 20, 2014, rjamya <rjamya_at_gmail.com> wrote:

> Index creation never runs in parallel worker processes, only data load can
> run in parallel. Even metasata load/unload is run by a single worker
> process.
> You will need to trace impdp to find why something is fast and slow.
> Google for 'expdp trace'.
>
> I think even on 12.1 index creation is run by only one thread. It may use
> PX slaves if index was originally parallel by only one worker thread does
> that whilest others are idle.
>
> Raj
>

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