Re: Actual PQ processes used by a query
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Thu, 16 Sep 2021 17:09:45 +0200
Message-ID: <CAOVevU62gU44X9nuW0oceUF5gz1jGpueBrUifnHp9imjV8A7_w_at_mail.gmail.com>
Date: Thu, 16 Sep 2021 17:09:45 +0200
Message-ID: <CAOVevU62gU44X9nuW0oceUF5gz1jGpueBrUifnHp9imjV8A7_w_at_mail.gmail.com>
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_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-lReceived on Thu Sep 16 2021 - 17:09:45 CEST