Re: best way to invoke parallel in DW loads?
From: Greg Rahn <greg_at_structureddata.org>
Date: Wed, 16 Sep 2009 11:38:41 -0700
Message-ID: <a9c093440909161138q5abd2ca8j6c5cc6dfffc0018d_at_mail.gmail.com>
I'm quite certain that with 9.1 any restrictions on doing PDML on a single segment were removed and certainly in 10.1 PDML works on a single segment by doing granule based PDML vs segment based. Perhaps the documentation is incorrect.
Date: Wed, 16 Sep 2009 11:38:41 -0700
Message-ID: <a9c093440909161138q5abd2ca8j6c5cc6dfffc0018d_at_mail.gmail.com>
I'm quite certain that with 9.1 any restrictions on doing PDML on a single segment were removed and certainly in 10.1 PDML works on a single segment by doing granule based PDML vs segment based. Perhaps the documentation is incorrect.
On Wed, Sep 16, 2009 at 9:04 AM, Herring Dave - dherri
<Dave.Herring_at_acxiom.com> wrote:
> But, for UPDATEs and DELETEs, your main gain with
> parallel DML is with partitioned objects. At least that was the case in
> 9i, as I believe the doc explicitly listed this (of course my quick
> check didn't confirm this, so may be full of it).
-- Regards, Greg Rahn http://structureddata.org -- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 16 2009 - 13:38:41 CDT