connections or sessions? Did you also enable parallel dml for the session?
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Sanjay Mishra (Redacted sender "smishra_97" for DMARC)
Sent: Wednesday, August 15, 2018 4:41 PM
To: Oracle-L Freelists
Subject: Oracle Partitioning and parallel DML
Can someone help to understand the Parallel DML doing INSERT and partitions? I
had two partitioned table with 7 partitions in one table where Insert is going
and 5 partitions in the second table which is used in SELECT
Using session level force Paralle DML 5
INSERT /APPEND/ into 7_part_table select from 5Part_table
This is Oracle Exadata, 2 two node RAC with 12.1. I can see that the above
insert create more than 20 connections and causing a high bottleneck to the
system Resource and affecting the other process. Is it suppose to create these
many processes.
DOP is manual
Table/corresponding Index Level Degree is set as 1
TIA
Sanjay