Re: Parallel Distributed CTAS
From: Greg Rahn <greg_at_structureddata.org>
Date: Fri, 4 Feb 2011 08:35:37 -0800
Message-ID: <AANLkTikgNdWsB=3Ou5X63cVGdUnAN8Y-sm3H5DO2MrhO_at_mail.gmail.com>
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).
Date: Fri, 4 Feb 2011 08:35:37 -0800
Message-ID: <AANLkTikgNdWsB=3Ou5X63cVGdUnAN8Y-sm3H5DO2MrhO_at_mail.gmail.com>
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_at_seb.lt> 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 -- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 04 2011 - 10:35:37 CST