Re: Parallel Threads
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: kennaim@xxxxxxxxx
- 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@xxxxxxxxx> 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.'
Other related posts:
