Insert statement with Parallel direct load

[himridul]

Hi,

I'm running the query below in Explain Plan window:

INSERT /*+ PARALLEL(emp,12) */ INTO emp
SELECT /*+ PARALLEL(t_emp,12) */ * FROM t_emp;

In "Other Tag" option in Explain Plan ,
For SELECT statement it's showing PARALLEL_TO_SERIAL
But
For INSERT statement it's showing Nothing (NULL).

As far I know , INSERT /*+ PARALLEL(emp,12) */ INTO emp
means PARALLEL execution mode with APPEND (default for PARALLEL).

Then why it's not showing in EXPLIAN PLAN ?
Is the INSERT statement not running in PARALLEL?

Any help will be highly appreciated ..

 

[himridul]

Any idea regarding this ......