Topic: SQL*Plus and PL/SQL >> parallel processing.
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: parallel processing. |
| |
Posted: Feb 19, 2007 06:58:30 AM |
Total Post: 15
Joined: Dec, 2006
|
Thanx in advance....
I want to execute a procedure simultaneously in 10 threads with different arguments how can i do??
if anyone of u hv any information abt this parallel processing thn plz reply...
|
|
|
 |
| Posted: Feb 19, 2007 07:13:46 AM |  |
|
Total Post: 15
Joined: Dec, 2006
|
|
|
|
|
| ravisurya |
| Posted: Feb 19, 2007 07:27:13 AM | |
|
Total Post: 4
Joined: Oct, 2006
|
for this You can create 10 threads in frontend(JAVA or ANY) and call same procedure 10 times by providing different inout parameters. But if it has 10 db connections then only it will run parallel.
From the database backend level you need write the code by using dbms_jobs package
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 843 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 272 |
| neeraj sharma | 252 |
| Ramesh Jois | 245 |
| Bishal Khetan | 207 |
|
|
