Re: RE: Oracle Partitioning and parallel DML

Mark
It is the session which is visible and yes Parallel DML was enabled for the session. Trying to understand as how Oracle create so many session which might be due to parallel queries and how they are related or how Oracle decide to start the number of parallel slaves. Is it depending solely on enable PARALLEL DML setting like I had 5 here?Is it depending on Partition in the involved table like for INSERT and SELECT?

ThanksSanjay

    On Wednesday, August 15, 2018, 5:34:22 PM EDT, Mark W. Farnham <mwf_at_rsiz.com> wrote:  

 #yiv0942948783 #yiv0942948783 -- _filtered #yiv0942948783 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv0942948783 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}#yiv0942948783 #yiv0942948783 p.yiv0942948783MsoNormal, #yiv0942948783 li.yiv0942948783MsoNormal, #yiv0942948783 div.yiv0942948783MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:New;}#yiv0942948783 a:link, #yiv0942948783 span.yiv0942948783MsoHyperlink {color:blue;text-decoration:underline;}#yiv0942948783 a:visited, #yiv0942948783 span.yiv0942948783MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv0942948783 span.yiv0942948783EmailStyle17 {color:#1F497D;}#yiv0942948783 .yiv0942948783MsoChpDefault {font-size:10.0pt;} _filtered #yiv0942948783 {margin:1.0in 1.0in 1.0in 1.0in;}#yiv0942948783 div.yiv0942948783WordSection1 {}#yiv0942948783 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-l