Re: Can't get INSERT /*+ APPEND */ to indicate direct load in execution plan.....
Date: Tue, 01 Nov 2011 00:50:44 +0100
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.
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 220.127.116.11.0 RAC on Linux x86-64.
>> The table is range partitioned, and has one XMLTYPE column with SECUREFILES BINARY XML storage.
> I found these:
> 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:
> 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
> Status 92 - Closed, Not a Bug