Running multiple instances of the same job

Hi All,

I have a plsql stored procedure that I am submitting as a job using dbms_job.submit. The procedure accepts user id as a param writes to a single table that has a user_id column apart from other columns (distinct rows for users). Also the amount of execution time is different for different user (ranging anywhere from 3 mins to 25 mins). I have a situation where multiple users would submit requests for the job and I want to run them in parallel. I read on AskTom that I could set the job_queue_processes to the number of jobs that I want to run and this would enable execution in parallel. I would like to know if this approach would work in my case as the plsql proc is actually writing to the same table ? Will this lead into any kind of contention.

Thanks much for your help Received on Thu Jul 29 2004 - 09:38:07 CDT