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

From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Mon, 31 Oct 2011 15:34:13 -0400
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F7B6E3D87_at_AAPQMAILBX02V.proque.st>

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_at_gmail.com] Sent: Monday, October 31, 2011 3:30 PM
To: Bobak, Mark
Cc: oracle-l_at_freelists.org
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_at_proquest.com<mailto:Mark.Bobak_at_proquest.com>> 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

--

http://www.freelists.org/webpage/oracle-l Received on Mon Oct 31 2011 - 14:34:13 CDT