Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....

From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Mon, 31 Oct 2011 15:41:16 -0700 (PDT)
Message-ID: <1320100876.42546.YahooMailNeo_at_web65410.mail.ac4.yahoo.com>



I understand this but the query is clearly using parallel hints, hence the post.

David Fitzjarrell

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:
> http://download.oracle.com/docs/cd/E11882_01/server.112/e25494/tables004.htm#ADMIN13320
>
> 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-l
Received on Mon Oct 31 2011 - 17:41:16 CDT

Original text of this message