What happens here is that you get a parallel select on the remote db, a parallel insert on the local db, but the communication between the two nodes over the db link is done via the QC so its 1:1 (or serial). On Fri, Feb 4, 2011 at 4:23 AM, <Laimutis.Nedzinskas@xxxxxx> wrote: > What is a pipe ? You mean network ? > My understanding is that network is not an issue. > > It is how oracle handles it. Execution plans do differ for remote and > local, that's true: > > -- Regards, Greg Rahn http://structureddata.org