RE: Parallel Threads

From: Kenneth Naim <>
Date: Wed, 11 Mar 2009 10:43:30 -0400
Message-ID: <3AA5C4DA5D29415E8E2BE1E5621DB994_at_KenPC>

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?  



From: Andrew Kerber [] Sent: Wednesday, March 11, 2009 10:33 AM To:
Subject: Re: Parallel Threads  

Do you have parallel_adaptive_multi_user turned on?

As far as I know, that is the only way parallel operations will get degraded.

Try this (remove the g if not in a cluster):

SELECT inst_id, name, value FROM gv$sysstat WHERE name LIKE 'Parallel%';

On Wed, Mar 11, 2009 at 8:35 AM, Kenneth Naim <> wrote:

How can I tell how many parallel threads were spawned by a parallel query after the query completed. I have a query that normally takes a couple hours but ran for 24 hours over the weekend. My theory is that the 40 parallel threads were reduced by the optimizer for some reason so I'd like to know how many threads it used.  



Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

Received on Wed Mar 11 2009 - 09:43:30 CDT

Original text of this message