Re: Parallel Threads
From: Greg Rahn <greg_at_structureddata.org>
Date: Wed, 11 Mar 2009 07:53:56 -0700
Message-ID: <a9c093440903110753t1bbccc1fmc448af3ace53bd59_at_mail.gmail.com>
http://dioncho.wordpress.com/2009/02/20/how-was-my-parallel-query-executed-last-night-awr/
Date: Wed, 11 Mar 2009 07:53:56 -0700
Message-ID: <a9c093440903110753t1bbccc1fmc448af3ace53bd59_at_mail.gmail.com>
http://dioncho.wordpress.com/2009/02/20/how-was-my-parallel-query-executed-last-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 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 11 2009 - 09:53:56 CDT