Parallel Execution
611496Feb 7 2008 — edited Feb 8 2008hi
Here is a senario
select * from emp
--this would run with a single thread
select /*+PARALLEL (emp,10)*/ * from emp
-- this query would run with 10 threads
now considering
ALTER SESSION FORCE PARALLEL QUERY PARALLEL 2
select /*+PARALLEL (emp,10)*/ * from emp
--
will this run with 10 threads or 10*2 = 20 threads
Please let me know