Actual PQ processes used by a query

  • From: "Hameed, Amir" <amir.hameed@xxxxxxxxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 16 Sep 2021 14:55:57 +0000

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