Re: Running multiple instances of the same job

>> Will this lead into any kind of contention.
It may. As a matter of fact, it will.

You`re the only one who can tell how it can affect you. Your disks will be more sollicited if you have more users accessing them at the same time. And the CPU too. Same for the Oracle structures. You`ll have to learn about them, and it all depends on what exactly your procedure is doing.

On a rightly tuned database and OS you`re still far better off running multiple instances at the same time than one after the other, though.

If you want multiple instances of this procedure to run at the same time, increasing job_queue_processes is the way to go.

-- 
Syltrem

OpenVMS 7.3-1 + Oracle 8.1.7.4
http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
---zulu is not in my email address---
"Manish" <manishrb_at_hotmail.com> a écrit dans le message de
news:55e6afeb.0407290638.50242f69_at_posting.google.com...


> 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