Re: Parallel Threads

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Wed, 11 Mar 2009 09:33:00 -0500
Message-ID: <ad3aa4c90903110733w2cdb0c09s1d10263a7d7101a9_at_mail.gmail.com>

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 <kennaim_at_gmail.com> 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.
>
>
>
> Thanks,
>
> Ken
>

-- 
Andrew W. Kerber

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

--
http://www.freelists.org/webpage/oracle-l

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