General
cancel
Showing results for 
Search instead for 
Did you mean: 

Parralelism of independant batch job

Nicolas Dumeige
Esteemed Contributor

Parralelism of independant batch job

Hello,

I want to launch in parralel several PL/SQL procedures.

In your opinion, what would be the best choice to do so ?

Do you know obstacle in using DBMS_JOB for this purpose ?

Thanks

Nicolas
All different, all Unix
2 REPLIES
Ken_109
Advisor

Re: Parralelism of independant batch job

dbms_job will do the trick. Just make sure you have enough job process ( set in the pfile ) configured to handle your degree of parallelism.Alternatively, you may script the startup up and run through sqlplus and schedule through cron... The nice thing about dbms_job is that you don't need to wory to much about storing passwords etc... since oracle will actually run the pl/sql procs on your behalf....One thing to consider is do you really need these to run in parallel or could you get away with sequential. A general rule is to only set the degree of parallelism to 2x cpu counts... Thats a good place to start, your milage may vary.
Nicolas Dumeige
Esteemed Contributor

Re: Parralelism of independant batch job

To give the forum feed back on this, we finally used jobs + Advances Queing.

Several procedures are lauchned using jobs in parallel, each proc. send messages on completion or error. All proc. are waited until next step can begin.

Cheers

Nicolas
All different, all Unix