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

From: David Fitzjarrell <oratune@xxxxxxxxx>
To: "Mark.Bobak@xxxxxxxxxxxx" <Mark.Bobak@xxxxxxxxxxxx>, Niall Litchfield <niall.litchfield@xxxxxxxxx>
Date: Mon, 31 Oct 2011 12:42:31 -0700 (PDT)

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.

David Fitzjarrell


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

I thought about force logging.  Force logging isn't set, however, even if it 
were, correct me if I'm wrong, but that would only prevent 'NOLOGGING', not 
direct loads, right?
As to the parallel parameters, here's what I have:
SQL> show parameter parallel
fast_start_parallel_rollback        string      HIGH
parallel_adaptive_multi_user        boolean    TRUE
parallel_automatic_tuning            boolean    FALSE
parallel_degree_limit                string      CPU
parallel_degree_policy              string      MANUAL
parallel_execution_message_size      integer    16384
parallel_force_local                boolean    FALSE
parallel_instance_group              string
parallel_io_cap_enabled              boolean    FALSE
parallel_max_servers                integer    320
parallel_min_percent                integer    0
parallel_min_servers                integer    0
parallel_min_time_threshold          string      AUTO
parallel_server                      boolean    TRUE
parallel_server_instances            integer    5
parallel_servers_target              integer    128
parallel_threads_per_cpu            integer    2
recovery_parallelism                integer    0

Thanks,

-Mark

From: Niall Litchfield [mailto:niall.litchfield@xxxxxxxxx]
Sent: Monday, October 31, 2011 3:30 PM
To: Bobak, Mark
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Can't get INSERT /*+ APPEND */ to indicate direct load in 
execution plan.....

Well when I do something like this it usually ends up being because I've 
enabled forced logging and then forgotten about it. :)

The output from show parameter parallel might be worth investigating as well.

On Mon, Oct 31, 2011 at 7:09 PM, Bobak, Mark 
<Mark.Bobak@xxxxxxxxxxxx<mailto:Mark.Bobak@xxxxxxxxxxxx>> wrote:
Hi all,
I'm trying to get direct load insert working.  I'm running 11.2.0.2.0 RAC on 
Linux x86-64.



--
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
//www.freelists.org/webpage/oracle-l

--
//www.freelists.org/webpage/oracle-l

Follow-Ups:
- RE: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....
  - From: Bobak, Mark
- Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....
  - From: Greg Rahn

References:
- Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....
  - From: Bobak, Mark
- Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....
  - From: Niall Litchfield
- RE: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....
  - From: Bobak, Mark

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

Other related posts:

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