Is there a way to allow limiting number of running scheduler jobs per pool?
Is there a way to allow limiting number of running scheduler jobs per pool?
Let's say we have N entities which need to be processed by some Oracle procedure. Processing them one by one would be too slow. Processing all of them in parallel (e.g. spawn scheduler jobs for each entity) - could demand too much resources and overload the system. So what we'd like is to be able to say that we want all these N jobs (one for each entity) to run in such a way that just M (usually M<=N) of them to be running (others are waiting).
Let's say we have N entities which need to be processed by some Oracle procedure. Processing them one by one would be too slow. Processing all of them in parallel (e.g. spawn scheduler jobs for each entity) - could demand too much resources and overload the system. So what we'd like is to be able to say that we want all these N jobs (one for each entity) to run in such a way that just M (usually M<=N) of them to be running (others are waiting).
0