Re: Parallel Threads

From: Andrew Kerber <>
Date: Wed, 11 Mar 2009 09:33:00 -0500
Message-ID: <>

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 Id like to know
> how many threads it used.
> Thanks,
> Ken

Andrew W. Kerber

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

Received on Wed Mar 11 2009 - 09:33:00 CDT

Original text of this message