Hi Amir,
The easiest one is RTSM report (real time sql monitor report) or
v$pq_sesstat
Best regards,
Sayan Malakshinov
Oracle performance tuning expert
Oracle Database Developer Choice Award winner
Oracle ACE
http://orasql.org
чт, 16 сент. 2021 г., 16:56 Hameed, Amir <amir.hameed@xxxxxxxxxxxxxxx>:
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