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

From: Greg Rahn <>
Date: Mon, 31 Oct 2011 13:25:53 -0700
Message-Id: <>

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 <> 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.

Received on Mon Oct 31 2011 - 15:25:53 CDT

Original text of this message