RE: Auto DOP

From: <dimensional.dba_at_comcast.net>
Date: Fri, 14 Aug 2020 07:02:57 -0700
Message-ID: <1f2301d67243$9da9bb10$d8fd3130$_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

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.

Lothar
--

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

--

http://www.freelists.org/webpage/oracle-l Received on Fri Aug 14 2020 - 16:02:57 CEST

This message: [ Message body ]
Next message: Lothar Flatz: "Re: Auto DOP"
Previous message: "": "RE: Never seen this line in an execution plan before"
In reply to: Lothar Flatz: "Auto DOP"
Next in thread: Lothar Flatz: "Re: Auto DOP"
Reply: Lothar Flatz: "Re: Auto DOP"
Reply: dimensional.dba_at_comcast.net: "RE: Auto DOP"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message