Auto DOP

  • From: Lothar Flatz <l.flatz@xxxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 14 Aug 2020 14:05:05 +0200

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


Other related posts: