Version : 11.2.0.3 on RHEL 5.4
I have been asked to tune a query which has a DOP of 4
select /*+ parallel 4 */
I was under the impression that when you give DOP as 4 like above , 4 threads will be spawned to run the SELECT query.
But my colleague says , if you give DOP as 4 , actual threads spawned will be 4 times the number of cores
ie. If you have 2 CPUs with 4 cores on each , oracle will be spawning 4 times 8 = 32 threads to process this SQL query. Is this true ?