RE: [External] Wierd Parallel DDL Behaviour ?
Date: Fri, 16 Dec 2016 06:07:39 +0000
Message-ID: <2FE2AA1C5F8DEC478F58DF8DD32BA6370CF52166_at_HKWPIPXMB03C.zone1.scb.net>
In my experience, the specification at the statement overrides the session. If you are seeing different behaviour, create a reproducible test case, prove it and log an SR with Oracle Support.
Hemant K Chitale
From: Gokul Gopal [mailto:gokulkumar.gopal_at_gmail.com] Sent: Friday, December 16, 2016 12:49 PM To: Gokul Gopal; Chitale, Hemant K; Oracle-L Group Subject: RE: [External] Wierd Parallel DDL Behaviour ?
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
From: Gokul Gopal<mailto:gokulkumar.gopal_at_gmail.com> Sent: 16/12/2016 10:12
To: Chitale, Hemant K<mailto:Hemant-K.Chitale_at_sc.com>; Oracle-L Group<mailto:oracle-l_at_freelists.org> 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<mailto:Hemant-K.Chitale_at_sc.com> Sent: 16/12/2016 09:20
To: Gokul Gopal<mailto:gokulkumar.gopal_at_gmail.com>; Oracle-L Group<mailto:oracle-l_at_freelists.org> 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.
>> The above 2 statements are not behaving the same.
What difference do you find between the two operations ? How do you identify the difference ?
Many questions arise from a misinterpretation or incomplete view of information.
Hemant K Chitale
From: Gokul Gopal [mailto:gokulkumar.gopal_at_gmail.com]
Sent: Friday, December 16, 2016 11:20 AM
To: Chitale, Hemant K; Oracle-L Group
Subject: RE: [External] Wierd Parallel DDL Behaviour ?
Hi Hemant,
CREATE /* PARALLEL (4) */ TABLE T15.... CREATE TABLE T15 PARALLEL 4 The above 2 statements are not behaving the same. If parallelism is applied in either cases then both the above statements must be equivalent ?
Gokul Gopal
From: Chitale, Hemant K<mailto:Hemant-K.Chitale_at_sc.com> Sent: 16/12/2016 08:27
To: Gokul Gopal<mailto:gokulkumar.gopal_at_gmail.com>; Oracle-L Group<mailto:oracle-l_at_freelists.org> Subject: RE: [External] Wierd Parallel DDL Behaviour ? As a Hint, the Degree is specified in brackets.
Thus, when you say /*+ PARALLEL */ and want to specify a specific Degree , put it into brackets -- /*+ PARALLEL (4) */
[The entire original message is not included.]
This email and any attachments are confidential and may also be privileged. If you are not the intended recipient, please delete all copies and notify the sender immediately. You may wish to refer to the incorporation details of Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at https://www.sc.com/en/incorporation-details.html
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Dec 16 2016 - 07:07:39 CET