Running a multi-table insert in parallel
Hello all
I am running 11.2.0.2 on Windows 2008R2 X64 with 24 cores. I have an insert where the select-part runs fine in parallel, but the insert-part does not. I have remembered to alter session enable parallel dml. I have created a testcase that illustrates this. The complete test-case is attached, but the sql and the execution plans are also given below.
The real tables have 500 million rows of 300 bytes each, so the potential for timesaving is there. Any ideas why the insert does not want to parallelize?
Best regards Niels Jespersen
insert /*+ PARALLEL(8) */
all
into I1 (I1a, I1b, I1c)
I am running 11.2.0.2 on Windows 2008R2 X64 with 24 cores. I have an insert where the select-part runs fine in parallel, but the insert-part does not. I have remembered to alter session enable parallel dml. I have created a testcase that illustrates this. The complete test-case is attached, but the sql and the execution plans are also given below.
The real tables have 500 million rows of 300 bytes each, so the potential for timesaving is there. Any ideas why the insert does not want to parallelize?
Best regards Niels Jespersen
insert /*+ PARALLEL(8) */
all
into I1 (I1a, I1b, I1c)
0