RE: [External] Wierd Parallel DDL Behaviour ?
- From: Gokul Gopal <gokulkumar.gopal@xxxxxxxxx>
- To: "Chitale, Hemant K" <Hemant-K.Chitale@xxxxxx>, Oracle-L Group <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 16 Dec 2016 10:12:33 +0530
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
-----Original Message-----
From: "Chitale, Hemant K" <Hemant-K.Chitale@xxxxxx>
Sent: 16/12/2016 09:20
To: "Gokul Gopal" <gokulkumar.gopal@xxxxxxxxx>; "Oracle-L Group"
<oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxx] ;
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
Sent: 16/12/2016 08:27
To: Gokul Gopal; Oracle-L Group
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) */
Hemant K Chitale
From: Gokul Gopal [
mailto:gokulkumar.gopal@xxxxxxxxx] ;
Sent: Friday, December 16, 2016 10:49 AM
To: Chitale, Hemant K; Oracle-L Group
Subject: RE: [External] Wierd Parallel DDL Behaviour ?
Thanks Hemant.
Interestingly, if I remove /*+ parallel(4) */ and replace it with "parallel 4"
at the statement level, it stops working. Any idea why this might be happening?
Gokul Gopal
From: Chitale, Hemant K
Sent: 16/12/2016 07:09
To: gokulkumar.gopal@xxxxxxxxx; Oracle-L Group
Subject: RE: [External] Wierd Parallel DDL Behaviour ?
create /*+ parallel(4) */ table t15
Since at least 7.3.4
See the CREATE TABLE statement and the PARALLEL Clause in the 7.3.4
documentation available online
http://docs.oracle.com/pdf/A32538_1.pdf
(back then, Parallel Query was a licensed Option in the database)
Hemant K Chitale
From: oracle-l-bounce@xxxxxxxxxxxxx [
mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Gokul Kumar Gopal
Sent: Friday, December 16, 2016 4:07 AM
To: Oracle-L Group
Subject: [External] Wierd Parallel DDL Behaviour ?
Hello,
I am trying to understand the following run..
sqlplus <user>/<pwd>@db
SQL*Plus: Release 11.2.0.1.0 Production on Fri Dec 16 01:25:38 2016
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management,
OLAP,
Data Mining and Real Application Testing options</
[The entire original message is not included.]
Other related posts: