I'm struggling to imporve datapump import speed (local, not via network or dblink), doing no benefit, have tried these options:
parallel = 1 -> 3 hrs & 42 mins (no parallel is better)
parallel = 4 -> 3 hrs & 51 mins
parallel = 8 -> 4 hrs & 6 mins
have 4 cpus, linux 64 bit, Oracle 10.2.0.3.
Highly appreciate, you expert/experienced thoughts.