Parallel Threads
From: Kenneth Naim <kennaim_at_gmail.com>
Date: Wed, 11 Mar 2009 09:35:03 -0400
Message-ID: <E4F7B5022505450C949A400CF85253DC_at_KenPC>
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.
Date: Wed, 11 Mar 2009 09:35:03 -0400
Message-ID: <E4F7B5022505450C949A400CF85253DC_at_KenPC>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 11 2009 - 08:35:03 CDT