Re: Re: "parallel query server generated this plan"

Hi Lothar,

If the px slave runs on another instance, it needs to generate a local plan for the SQL (I'm not sure if this is required in same instance also, or if there is a shortcut between qc and px so it can get the plan directly). This is a situation where I see the px creating a plan.

br
 Martin

Am Di., 21. Apr. 2020 um 10:59 Uhr schrieb l.flatz_at_bluewin.ch < l.flatz_at_bluewin.ch>:

> 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_at_gmail.com
> Datum : 21/04/2020 - 07:48 (MS)
> An : l.flatz_at_bluewin.ch
> Cc : oracle-l_at_freelists.org
> 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_at_bluewin.ch>:
>
>> 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
>>
>>
>> --
>>
>>
>>
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>>
>>
>>
>
>

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