Do you really need 100 sessions to migrate 7 Million rows? I doubt it.We have 100 sessions open through parallel executions maigrating 7 million of customer data.
Try with single session.
The v$sess_io is the best monitoring view to know about IO performance of the running session.




Reply With Quote