Actual PQ processes used by a query
From: Hameed, Amir <amir.hameed_at_sleepnumber.com>
Date: Thu, 16 Sep 2021 14:55:57 +0000
Message-ID: <CH0PR14MB501292406205B96BBA7F194AE0DC9_at_CH0PR14MB5012.namprd14.prod.outlook.com>
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?
Date: Thu, 16 Sep 2021 14:55:57 +0000
Message-ID: <CH0PR14MB501292406205B96BBA7F194AE0DC9_at_CH0PR14MB5012.namprd14.prod.outlook.com>
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-lReceived on Thu Sep 16 2021 - 16:55:57 CEST