You Asked
I'm doing a direct path insert over a DBlink. I'm testing the impact of doing both the select and the insert in parallel. If I hint well both the insert and the select and enable parallel DML, will multiple connections would be open for each slave process generated? Are there any issues that the DBlink could introduce.
and Tom said...
we will serialize over the dblink.
the select can be in parallel
the insert as well
but there will be a single database link over which the data flows.
Rating
(1 rating)
Is this answer out of date? If it is, please let us know via a Comment