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!
Asked
Active
Viewed 3,361 times
1
cristian
- 8,676
- 3
- 38
- 44
-
1See http://stackoverflow.com/questions/576802/can-we-use-threading-in-pl-sql – TTT Jan 08 '11 at 17:52
2 Answers
0
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
Ranzo Taylor
- 99
- 4
-1
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
chris
- 89
- 6
-
The first sentence isn't correct, the parallel execution you mention takes place for "one" sql/plsql. Ex: select /*+PARALLEL(a,4)*/ * from table. Rephrase maybe? – Ranzo Taylor Sep 13 '11 at 22:47