RE: Oracle Partitioning and parallel DML
Date: Wed, 15 Aug 2018 17:33:10 -0400
Message-ID: <00e901d434df$90d163a0$b2742ae0$_at_rsiz.com>
connections or sessions? Did you also enable parallel dml for the session?
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 15 2018 - 23:33:10 CEST