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

  • From: David Fitzjarrell <oratune@xxxxxxxxx>
  • To: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>, Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
  • Date: Mon, 31 Oct 2011 14:49:03 -0700 (PDT)

http://download.oracle.com/docs/cd/E11882_01/server.112/e25494/tables004.htm#ADMIN13320
 
Described under "Parallel Mode Inserts with SQL Statements".
David Fitzjarrell


From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
To: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>; "oratune@xxxxxxxxx" <oratune@xxxxxxxxx>
Cc: Niall Litchfield <niall.litchfield@xxxxxxxxx>; "oracle-l@xxxxxxxxxxxxx" 
<oracle-l@xxxxxxxxxxxxx>
Sent: Monday, October 31, 2011 1:29 PM
Subject: RE: Can't get INSERT /*+ APPEND */ to indicate direct load in 
execution plan.....


I thought about that possibility, but I could find no such limitation 
documented anywhere.
 
Also, I moved from a preprod to a test instance, and it started working.  
Iâ??ll need to revisit preprod, to see the difference, but, it is working now, 
so the problem was not the datatype.
 
-Mark
 
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.
--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 10-2011