Parralelism of independant batch job

[Nicolas Dumeige]

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

[Ken_109]

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]

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