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.'