Do all the tables in the execution plan have a degree set or are some set to
DEFAULT? If any are set to DEFAULT then AUTO DOP can come into play and
depending on which table drives the joins it sets the DOP for the whole plan
12.x-20.x.
What is the DOP set on the tables in your execution plan?
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> On Behalf
Of Lothar Flatz
Sent: Friday, August 14, 2020 5:05 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Auto DOP
Hi,
In the plan note of one of my customers I see on regular terms:
- automatic DOP: Computed Degree of Parallelism is 8 because of degree limit.
However parallel_degree_policy is set to MANUAL and the query runs parallel
because the tables have a degree set.
Why does the note say "automatic DOP"?
Version is 19.3 Hardware is Exadata Cloud at Customer.
regards
Lothar
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
