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

From: Greg Rahn <greg_at_structureddata.org>
Date: Mon, 31 Oct 2011 15:24:02 -0700
Message-ID: <CAGXkmitG7gBpWBjL8ogsR9cQ1YP40k5q5TGZwwiKho2vah+FTQ_at_mail.gmail.com>



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:24:02 CDT

Original text of this message