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 13:25:53 -0700
Message-Id: <5484F189-F83B-41F1-9D94-B9A653B83DC3_at_structureddata.org>



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.

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 31 2011 - 15:25:53 CDT

Original text of this message