SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBMS_JOB.SUBMIT - Parallel execution of jobs

sri333Apr 25 2013 — edited Apr 25 2013

Hi,
I have submitted two jobs by using dbms_job.submit(). I want to know whether they will get executed in parallel or in queue. Please see below example

EX: My task is to run the same procedure with different parametrs so i tried the following.

dbms_job.submit(job_id=>v1,'example_proc(10);');
dbms_job.submit(job_id=>v1,'example_proc(20);');

My question is now they will get executed in parallel or in queue. If in Queue how can i make them parallel.

thanks,
Sri

Locked Post

New comments cannot be posted to this locked post.

Locked on May 23 2013

Added on Apr 25 2013

7 comments

960 views