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