Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....
Date: Mon, 31 Oct 2011 15:41:16 -0700 (PDT)
I understand this but the query is clearly using parallel hints, hence the post.
From: Greg Rahn <greg_at_structureddata.org>
To: David Fitzjarrell <oratune_at_yahoo.com>
Cc: "Bobak, Mark" <Mark.Bobak_at_proquest.com>; Niall Litchfield <niall.litchfield_at_gmail.com>; "oracle-l_at_freelists.org" <oracle-l_at_freelists.org>
Sent: Monday, October 31, 2011 3:24 PM
Subject: Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....
To clarify your points:
- Auto DOP isn't a requirement for DPIs (direct path inserts) or parallel DPIs - PDML isn't a requirement for DPI
There can be non-parallel DPIs as well as non-PDML DPIs by simply using the APPEND hint.
On Mon, Oct 31, 2011 at 2:49 PM, David Fitzjarrell <oratune_at_yahoo.com> wrote:
> Described under "Parallel Mode Inserts with SQL Statements".
> From: Greg Rahn [mailto:greg_at_structureddata.org]
> Sent: Monday, October 31, 2011 4:26 PM
> To: oratune_at_yahoo.com
> Cc: Bobak, Mark; Niall Litchfield; oracle-l_at_freelists.org
> Subject: Re: Can't get INSERT /*+ APPEND */ to indicate direct load in
> execution plan.....
> Incorrect. You don't need either of those to have direct path inserts.
> Could it be related to a restriction the complex data types?
> On Oct 31, 2011, at 12:42 PM, David Fitzjarrell <oratune_at_yahoo.com> wrote:
> parallel_degree_policy string MANUAL
> This should be set to AUTO to enable direct path inserts in parallel mode.
> Also the session must have parallel dml enabled:
> alter session enable parallel dml;
> Once those two changes are made you should see direct path enable and
> displayed in the plan.
-- Regards, Greg Rahn http://structureddata.org -- http://www.freelists.org/webpage/oracle-lReceived on Mon Oct 31 2011 - 17:41:16 CDT