Re: Running multiple instances of the same job

I am sure that you already have a primary key with user_id as part of it.

On 29 Jul 2004 07:38:07 -0700, manishrb_at_hotmail.com (Manish) wrote:

>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 Fri Jul 30 2004 - 07:29:09 CDT