SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBMS_SCHEDULER parallel execution

818345May 5 2011 — edited May 6 2011

Hello,
I've got some procedures that I want to execute in parallel during a batch processing, and I thought of creating a job for each one of them and a DBMS_SCHEDULER Chain to launch them all together.
My question is, is it possible to control the number of jobs that are running simmultaneoulys?? If I have 4 job's that's not much of a problem, but if I get to 400 job's I wouldn't want to have them all trying to run together,

Thanks for your help

Edited by: Pedro_gloria on 5/Mai/2011 11:58 (typo)

This post has been answered by Ganesh Srivatsav on May 6 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 3 2011

Added on May 5 2011

4 comments

4,460 views