Re: Parallel Threads
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_at_gmail.com> wrote:
> I'll have to check this from home as the site is blocked by our lovely
> corporate websense.
> -----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
> 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
> > 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?
> Greg Rahn
-- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 11 2009 - 10:11:08 CDT