Oracle PL/SQL Parallel execution [duplicate]

This question already has answers here: Can We use threading in PL/SQL? (9 answers) Closed 8 years ago.

I need to write something about PL/SQL Parallel execution for a homework and i don't find a good tutorial that talks about this 开发者_如何转开发(i just need material about parallel execution of PL/SQL). Please, if you know some materials share them. Thanks in advance!

---

Here's your answer: parallel pipelined PL/SQL functions. Check it out here (thanks Tom!) http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:39946845137685

---

usually a dbms will not do parallel execution for one sql/plsql because it will handle concurrent users. so work load balancing is usually based on parallel sessions an not on single executions. newer the less you can use some tricks to get parallel execution 1.) use union all 2.) use partitioned tables and the parallel hint 3.) use dbms_jobs for parallel processing

For details just google these keywords or search trough asktom