Re: Actual PQ processes used by a query

  • From: Luis Claudio Dias dos Santos <lsantos@xxxxxxxxx>
  • To: amir.hameed@xxxxxxxxxxxxxxx
  • Date: Fri, 17 Sep 2021 10:14:46 -0300

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@xxxxxxxxxxxxxxx> 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



Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 09-2021