RE: Parallel Threads

  • From: "Kenneth Naim" <kennaim@xxxxxxxxx>
  • To: "'Greg Rahn'" <greg@xxxxxxxxxxxxxxxxxx>
  • Date: Wed, 11 Mar 2009 11:06:43 -0400

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/

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

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


Other related posts: