More information...
If I set "enable" instead of "force", I don't see this happening.
As per the documentation, parallelism given at statement level overrides the
session level setting. But in this case the statement level hint is ignored and
default parallelism is used.
Gokul Gopal
-----Original Message-----
From: "Gokul Gopal" <gokulkumar.gopal@xxxxxxxxx>
Sent: 16/12/2016 10:12
To: "Chitale, Hemant K" <Hemant-K.Chitale@xxxxxx>; "Oracle-L Group"
<oracle-l@xxxxxxxxxxxxx>
Subject: RE: [External] Wierd Parallel DDL Behaviour ?
Hi Hemant,
The first statements runs in 3 mins. The second statement doesn't complete.
Besides, the second statement generated about 300 sessions and was still
running.
Gokul Gopal
From: Chitale, Hemant K
Sent: 16/12/2016 09:20
To: Gokul Gopal; Oracle-L Group
Subject: RE: [External] Wierd Parallel DDL Behaviour ?
The first statement explicitly specifies the Degree to be used for the CREATE
operation.
The second statement specifies the Degree associated with the table.
What difference do you find between the two operations ? How do you identifyThe above 2 statements are not behaving the same.