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