RE: Auto DOP

If you want the parallelism to be match the higher values of the actual table settings you would need to change the DEFAULT ones to an actual value equally to what you need.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Lothar Flatz Sent: Friday, August 14, 2020 7:26 AM
To: dimensional.dba_at_comcast.net; oracle-l_at_freelists.org Subject: Re: Auto DOP

Hi ,

there are some with DEFAULT.

Thanks.

Lothar

Am 14.08.2020 um 16:02 schrieb dimensional.dba_at_comcast.net:
> 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_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Lothar Flatz
> Sent: Friday, August 14, 2020 5:05 AM
> To: oracle-l_at_freelists.org
> 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
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l