Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....
From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Mon, 31 Oct 2011 19:30:11 +0000
Message-ID: <CABe10sbAico4G3tKnUVmqgv7HtDA2nspzqswxEqheMb0PMYn+A_at_mail.gmail.com>
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.
Date: Mon, 31 Oct 2011 19:30:11 +0000
Message-ID: <CABe10sbAico4G3tKnUVmqgv7HtDA2nspzqswxEqheMb0PMYn+A_at_mail.gmail.com>
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>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-lReceived on Mon Oct 31 2011 - 14:30:11 CDT