Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Parallel Execution

611496Feb 7 2008 — edited Feb 8 2008
hi

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 7 2008
Added on Feb 7 2008
4 comments
319 views