Re: Parallel Threads

select sql_id, px_servers_execs_total, px_servers_execs_delta

from *dba_hist_sqlstat *

where sql_id = '&sql_id'

and snap_id = (select max(snap_id) from dba_hist_snapshot)

On Wed, Mar 11, 2009 at 10:06 AM, Kenneth Naim <kennaim_at_gmail.com> wrote:

> I'll have to check this from home as the site is blocked by our lovely
> corporate websense.
>
> Ken
>
> -----Original Message-----
> From: Greg Rahn [mailto:greg_at_structureddata.org]
> Sent: Wednesday, March 11, 2009 10:54 AM
> To: kennaim_at_gmail.com
> Cc: Andrew Kerber; oracle-l_at_freelists.org
> Subject: Re: Parallel Threads
>
>
> http://dioncho.wordpress.com/2009/02/20/how-was-my-parallel-query-executed-l
> ast-night-awr/<http://dioncho.wordpress.com/2009/02/20/how-was-my-parallel-query-executed-l%0Aast-night-awr/>
>
> On Wed, Mar 11, 2009 at 7:43 AM, Kenneth Naim <kennaim_at_gmail.com> wrote:
> > Yes I have parallel_adaptive_multi user set to true. And v$sysstat shows
> 1
> > operation downgraded by 50-75% and one downgraded by 25-50% and 45 not
> > downgraded. Is there a way to tell which statements were downgraded?
>
>
> --
> Regards,
> Greg Rahn
> http://structureddata.org
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l