Re: Actual PQ processes used by a query

Hi,

I use this simple script.

> *col sid format 999999**col dop_down format 990D99*

>
> *select INST_ID, SID, sql_id, sql_exec_id, PX_SERVERS_REQUESTED,
> PX_SERVERS_ALLOCATED,
> nvl((1-(PX_SERVERS_ALLOCATED/PX_SERVERS_REQUESTED))*100, 100) DOP_DOWN*
> *from gv$sql_monitor*
> *where PX_SERVERS_REQUESTED > PX_SERVERS_ALLOCATED**order by DOP_DOWN
> desc;*

<https://about.me/lcdsantos?promo=email_sig&utm_source=product&utm_medium=email_sig&utm_campaign=edit_panel&utm_content=thumb> Luis Santos
about.me/lcdsantos
<https://about.me/lcdsantos?promo=email_sig&utm_source=product&utm_medium=email_sig&utm_campaign=edit_panel&utm_content=thumb>

Em qui., 16 de set. de 2021 às 11:56, Hameed, Amir < amir.hameed_at_sleepnumber.com> escreveu:

> Hi,
>
> Is there a way to find out how many parallel processes a query used during
> execution? For example, if I have a parallel hint in a statement with DOP
> specified as 8 but at the time of execution, there were only 4 parallel
> processes available and the query ended up using only those processes, is
> there a way to validate that?
>
>
>
> Thanks,
> Amir
>
>
>

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