RE: [EXTERNAL] Re: Actual PQ processes used by a query

Hi Sayan,
Thank you for your reply. It seems that V$PQ_SESSTAT can help if it is queried interactively from the same session that ran the statement. Also, this view does not contain SID information and therefore, it cannot be used to query past executions.

From: Sayan Malakshinov <xt.and.r_at_gmail.com> Sent: Thursday, September 16, 2021 11:10 AM To: Hameed, Amir <amir.hameed_at_sleepnumber.com> Cc: ORACLE-L <oracle-l_at_freelists.org> Subject: [EXTERNAL] Re: Actual PQ processes used by a query

CAUTION: External source

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<https://nam10.safelinks.protection.outlook.com/?url=http%3A%2F%2Forasql.org%2F&data=04%7C01%7Camir.hameed%40sleepnumber.com%7C933fce4c37114a3bd37d08d979240ca4%7Ced8aabd514de49829fb6d6528851af5e%7C0%7C0%7C637674018014272194%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=hfmL%2FK2958th00uytYIoH9NG6fWqwDvpmnwGgc4O1Ls%3D&reserved=0>

ÞÔ, 16 ÓÅÎÔ. 2021 Ç., 16:56 Hameed, Amir <amir.hameed_at_sleepnumber.com<mailto:amir.hameed_at_sleepnumber.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-l