Home » SQL & PL/SQL » SQL & PL/SQL » Run procedure parallaly
Run procedure parallaly [message #337819] Fri, 01 August 2008 05:13 Go to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
begin
 upd_emp(db1);
 upd_emp(db2);
 upd_emp(db3);
 upd_emp(db4);
 upd_emp(db5);
 upd_emp(db6);
 upd_emp(db7);
 upd_emp(db8);
 upd_emp(db9);
 upd_emp(db10);
end;


db1..db10 database names.
each procedures took 30 minutes to complete.

Can we have any functionality in oracle PLSQL so that i can run 10 different upd_emp(db_name) procedures PARALLALY.

Thanks,
Re: Run procedure parallaly [message #337824 is a reply to message #337819] Fri, 01 August 2008 05:17 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Not from a single procedure. There's no forking in PL/SQL
You might kick off some jobs to do the processing for you.
Re: Run procedure parallaly [message #337827 is a reply to message #337819] Fri, 01 August 2008 05:20 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Because i need to run on 77 databases Smile
In that case i need to write 77 jobs for that Sad

Job1 : call upd_emp(db1)
Job2 : call upd_emp(db1)
.
.
.
Job77 : call upd_emp(db0)

I think it is somwhat lengthy solution.
Is there any other way?

Thanks,

[Updated on: Fri, 01 August 2008 05:21]

Report message to a moderator

Re: Run procedure parallaly [message #337831 is a reply to message #337827] Fri, 01 August 2008 05:24 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Don't be lazy.
After all, it's just a copy-paste thing.
"It's a lot of work" is the lousiest excuse I ever heard (and I heard it far too often).
Re: Run procedure parallaly [message #337832 is a reply to message #337827] Fri, 01 August 2008 05:25 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you want 10 parallel runs then you must have at least 10 jobs.
Then you can have a central table to distribute your databases among the jobs.

Regards
Michel
Previous Topic: Hows Oracle Lock Works
Next Topic: Calling procedure scenario
Goto Forum:
  


Current Time: Sun Dec 04 14:32:10 CST 2016

Total time taken to generate the page: 0.09467 seconds