Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: Mark.Bobak@xxxxxxxxxxxx
- Date: Mon, 31 Oct 2011 19:30:11 +0000
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>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
Other related posts:
- » Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Bobak, Mark
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan..... - Niall Litchfield
- » RE: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Bobak, Mark
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- David Fitzjarrell
- » RE: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Bobak, Mark
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Greg Rahn
- » RE: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Bobak, Mark
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- David Fitzjarrell
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Greg Rahn
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- David Fitzjarrell
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Radoulov, Dimitre
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Radoulov, Dimitre
- » RE: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Chitale, Hemant Krishnarao
- » RE: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Bobak, Mark
- » RE: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Bobak, Mark
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- jonathan
- » RE: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Bobak, Mark
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Radoulov, Dimitre
- » RE: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Bobak, Mark
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Radoulov, Dimitre
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Greg Rahn
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Radoulov, Dimitre
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Greg Rahn
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Radoulov, Dimitre
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Greg Rahn
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Radoulov, Dimitre
- » Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....- Niall Litchfield