http://www.orafaq.com/faqopq.htm

some faq on oracle’s parallel query processing