Re: Parallel Threads
Date: Wed, 11 Mar 2009 09:33:00 -0500
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.
-- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 11 2009 - 09:33:00 CDT