Hi Martin,
it is a typo. It ment to read "This was the note associated with the plan."
I now believe it means that the plan was produced by a px slave because the qc
was killed.
Thanks
Lothar
----Ursprüngliche Nachricht----
Von : martin.a.berger@xxxxxxxxx
Datum : 21/04/2020 - 07:48 (MS)
An : l.flatz@xxxxxxxxxx
Cc : oracle-l@xxxxxxxxxxxxx
Betreff : Re: "parallel query server generated this plan"
Hi Lothar,
can you please explain
> This was the plan not associated with the plan.
I don't understand this sentences meaning.
sorry,
Martin
Am Mo., 20. Apr. 2020 um 17:03 Uhr schrieb Lothar Flatz <
l.flatz@xxxxxxxxxx>:
Hi,
does anybody know what that means "parallel query server generated this
plan". One of my customers had a query running dop 280.
This was the plan not associated with the plan.
When I do an explain plan I get "automatic DOP: Computed Degree of
Parallelism is 32 because of degree limit", which is reasonable.
Regards
Lothar
--
--
//www.freelists.org/webpage/oracle-l