RE: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "cichomitiko@xxxxxxxxx" <cichomitiko@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 1 Nov 2011 09:30:45 -0400
Thanks Dimitre!
Yes, I do have serial direct load working now, and it appears that the
limitation on parallel direct load is due to the XMLTYPE column. I suspected
that was the problem, but wasn't seeing a documented restriction in that
regard. So, thanks for that!
Guess I'll have to suffer with serial direct load. Come to think of it, I
guess I could run multiple, concurrent, serial direct loads. I'll be looking
into that next.
-Mark
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Radoulov, Dimitre
Sent: Monday, October 31, 2011 7:51 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Can't get INSERT /*+ APPEND */ to indicate direct load in
execution plan.....
Just to add that I'm trying to clarify the missing parallel execution in the
insert part ( P->S ).
Mark could of course try with append without parallel (or with
noparallel) to see if direct operations take place.
Dimitre
On 01/11/2011 00:33, Radoulov, Dimitre wrote:
> On 31/10/2011 20:09, Bobak, Mark 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.
>>
>> The table is range partitioned, and has one XMLTYPE column with SECUREFILES
>> BINARY XML storage.
>>
> [...]
>
> I found these:
>
> bit.ly/tJlCBT
>
> No Parallel DML for XMLType -- DML operations on |XMLType| data are
> always performed in serial. Parallel DML is not supported for
> |XMLType|. (Parallel query and DDL are supported for |XMLType|.)
>
>
> I didn't read the whole document,
> but it seems that one could use parallel DML with the XMLIndexes:
>
> bit.ly/sIUkH0
>
> You can use a |PARALLEL| clause (with optional degree) when creating
> or altering an |XMLIndex| index to ensure that index creation and
> maintenance are carried out in parallel. If the base table is
> partitioned or enabled for parallelism, then this can improve the
> performance for both DML operations (|INSERT|, |UPDATE|, |DELETE|) and
> index DDL operations (|CREATE|, |ALTER|, |REBUILD|).
>
>
> And this one close as "Not a bug":
>
> Bug 6453331: INSERT INTO TABLE WITH COLUMN OF XMLTYPE IS NOT USING
> PARALLEL
>
> Status 92 - Closed, Not a Bug
>
--
//www.freelists.org/webpage/oracle-l
--
//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