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@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxxx]
> Sent: Monday, October 31, 2011 4:26 PM
> To: oratune@xxxxxxxxx
> Cc: Bobak, Mark; Niall Litchfield; oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxx> 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

Other related posts: