RE: impdp performance in 11.1 vs 11.2

  • From: rjamya <rjamya@xxxxxxxxx>
  • To: mschmitt@xxxxxxxxxxxx
  • Date: Wed, 20 Aug 2014 15:40:12 -0400

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

Other related posts: