Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....
Date: Mon, 31 Oct 2011 13:25:53 -0700
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.