Re: Parallel Threads
- From: Greg Rahn <greg@xxxxxxxxxxxxxxxxxx>
- To: kennaim@xxxxxxxxx
- Date: Wed, 11 Mar 2009 07:53:56 -0700
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@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 -- http://www.freelists.org/webpage/oracle-l
- Follow-Ups:
- RE: Parallel Threads
- From: Kenneth Naim
- RE: Parallel Threads
- References:
- Parallel Threads
- From: Kenneth Naim
- Re: Parallel Threads
- From: Andrew Kerber
- RE: Parallel Threads
- From: Kenneth Naim
- Parallel Threads
Other related posts:
- » Parallel Threads - Kenneth Naim
- » Re: Parallel Threads - Andrew Kerber
- » RE: Parallel Threads - Kenneth Naim
- » Re: Parallel Threads - Riyaj Shamsudeen
- » Re: Parallel Threads - Greg Rahn
- » RE: Parallel Threads - Kenneth Naim
- » RE: Parallel Threads - Kenneth Naim
- » Re: Parallel Threads - Andrew Kerber
- » RE: Parallel Threads - Kenneth Naim
- » Re: Parallel Threads - Riyaj Shamsudeen
- » RE: Parallel Threads - Kenneth Naim
- » RE: Parallel Threads - FmHabash