This content has been marked as final. Show 2 replies
No one can possibly answer the question you've asked nor would any answer have even the slightest value.
Your ability to choose parallel paths depends on (A) CPU threads available and (B) CPU threads utilized.
You have 4 threads you are going to have a hard time allocating 5
If you have 64 threads and 63 are already constantly in use you are going have an experience with slow.
That someone else had an issue is, as I indicated above, irrelevant just as the fact that I have never had one doesn't mean you won't.
Read up on parallel processes, what they are, how they work, and then look at your hardware and operating system.
I have really good experiences migrating 10g to 11g over database link. As you say long and long raw do not work but everything else seems fine ( lobs etc). Make sure you are patched up as high as you can go as there are lots of datapump bugs generally - not just with db links.
It's much more efficient that having to go out to a file.
Parallelism will do 5 separate tables at the same time - it does the biggest 5 first. Indexes will then be built with parallel 5 after the tables.
Just make sure streams pool and PGA are plenty big enough both sides.