Parallel DML (insert) not working

I am trying to execute something like

*alter session enable parallel dml;*

*insert /*+ parallel(ct,4) */ into core_tab ct select * from
different_table;*

Notes: Database version 11.2.0.3 , 2 node RAC, CORE_TAB is range partitioned and has 5 parent tables and also has a function based index on partition key column. Also , one of the parent table has self referential foreign key.

question: based on the explain plan i see that the insert is not running in parallel. then i came across the below restriction matrix in oracle docs

FOREIGN KEY (Referential Integrity)

Restrictions for referential integrity occur whenever a DML operation on one table could cause a recursive DML operation on another table. These restrictions also apply when, to perform an integrity check, it is necessary to see simultaneously all changes made to the object being modified.

Table 8-1<http://docs.oracle.com/cd/E11882_01/server.112/e25523/parallel003.htm#g1016143> lists
all of the operations that are possible on tables that are involved in referential integrity constraints.

Table 8-1 Referential Integrity Restrictions DML StatementIssued on ParentIssued on ChildSelf-Referential

*INSERT*

*(Not applicable)*

*Not parallelized*

*Not parallelized*

MERGE (Not applicable)

Not parallelized

Not parallelized

UPDATE No Action

Supported

Supported

Not parallelized

DELETE No Action

Supported

Supported

Not parallelized

DELETE Cascade

Not parallelized

(Not applicable)

Not parallelized

does it mean that parallel dml (insert) doesn't work on child tables ?

If its allowed , am i missing anything in the sql's i am running that's ignoring parallel hint for insert?

how to check why optimizer is not paralleling insert?

-- 




*Thanks&Regards       Anand(251-581-1153)*


--
http://www.freelists.org/webpage/oracle-l