Re: Parallel Threads
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: Kenneth Naim <kennaim@xxxxxxxxx>
- Date: Wed, 11 Mar 2009 10:11:08 -0500
I pulled this query out of the blog:
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@xxxxxxxxx> 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@xxxxxxxxxxxxxxxxxx]
> Sent: Wednesday, March 11, 2009 10:54 AM
> To: kennaim@xxxxxxxxx
> Cc: Andrew Kerber; oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxx> 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.'
Other related posts:
