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

Hello Amir,

You can find try to find the sql monitor report : How To Get Historical SQL Monitor Report For SQL Statements (Doc ID 2555350.1)

Another method:
DBA_HIST_ACTIVE_SESS_HISTORY has a column PX_FLAGS. you can calculate: TRUNC(px_flags / 2097152) dop.

În joi, 16 sept. 2021 la 19:25, Hameed, Amir <amir.hameed_at_sleepnumber.com> a scris:

> 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>:
>
> 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