Run the same procedure many times in parallel but no more than 10 at a time
567153Mar 15 2007 — edited Mar 15 2007I have a table filled with individual such criteria and want to run a stored pl/sql procedure to run searches on an external server on each of them. The stored procedure deals with the API and the external server can handle the concurrency.
I want to be able to the multiple searches concurrently (ie. run the stored procedure concurrently) but no more than 10 concurrent searches at a time (There are 20,000 searches to complete).
I'm thinking this should involve AQ whose messages call "run once" event based jobs from the Scheduler (I'm running on 10g) but I am very new to Oracle and hence not sure where to begin.
If somebody could fill in my obvious blanks and give me an approach that will actually achieve my end I would be extremely grateful!
Cheers, Kim.