Auto DOP

From: Lothar Flatz <l.flatz_at_bluewin.ch>
Date: Fri, 14 Aug 2020 14:05:05 +0200
Message-ID: <15077719-2691-000c-95cc-ca62b8f353fc_at_bluewin.ch>



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
Received on Fri Aug 14 2020 - 14:05:05 CEST

Original text of this message