No question at this time
DBA Top 10
1 A. Kavsek 10000
2 M. Cadot 9900
3 B. Vroman 5700
4 P. Wisse 4300
5 J. PĂ©ran 1800
6 . Lauri 1200
7 J. Schnackenberg 600
8 F. Pachot 500
9 Z. Hudec 400
9 G. Lambregts 400
9 N. Havard 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48503
Total active users1429
Act. users last 24h2
Act. users last hour0
Registered user hits last week104
Registered user hits last month599
Go up

Table decorated with parallel option and DOP is AUTO
Next thread: grant select one schema to another schema
Prev thread: Number of thread associated with DOP

Message Score Author Date
Hi, If I have a table decorated with the parall...... Lauri Nov 26, 2019, 13:50
Hi Lauri, It's complicated. Other factors are a...... Philip Wisse Nov 26, 2019, 17:06
Hi Philip, Is your answer not instead related to:...... Lauri Nov 27, 2019, 15:14
Hi Lauri, No that's a different thread. Mayb...... Philip Wisse Nov 27, 2019, 15:37
This is a good document.... Lauri Nov 27, 2019, 16:41

Follow up by mail Click here


Subject: Table decorated with parallel option and DOP is AUTO
Author: Lauri, Netherlands
Date: Nov 26, 2019, 13:50, 184 days ago
Os info: Linux x86 64bit
Oracle info: 12c and higher
Error info: n/a
Message: Hi,

If I have a table decorated with the parallel option, and on database level I have parallel_degree_policy=AUTO.
Will each query run against this table be parallelized?
I personally do not like that option when creating tables.

Kind Regards
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Table decorated with parallel option and DOP is AUTO
Author: Philip Wisse, Netherlands
Date: Nov 26, 2019, 17:06, 184 days ago
Message: Hi Lauri,

It's complicated. Other factors are also important:
https://www.oracle.com/technetwork/database/bi-datawarehousing/twp-parallel-execution-fundamentals-133639.pdf

HTH, Philip
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re-Table decorated with parallel option and DOP is AUTO
Author: Lauri, Netherlands
Date: Nov 27, 2019, 15:14, 183 days ago
Message: Hi Philip,
Is your answer not instead related to:
https://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=94306
Or does it applies to both?

Kind Regards
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Re-Table decorated with parallel option and DOP is AUTO
Author: Philip Wisse, Netherlands
Date: Nov 27, 2019, 15:37, 183 days ago
Message: Hi Lauri,

No that's a different thread.

Maybe it helps if you scroll down the document to the last page?

Regards, Philip
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re-Table decorated with parallel option and DOP is AUTO
Author: Lauri, Netherlands
Date: Nov 27, 2019, 16:41, 183 days ago
Message: This is a good document.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here