Skip to Main Content
Forums

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!

Can we use DBMS_JOB for parallel processing?

unknown-879931Jun 10 2015 — edited Jun 11 2015

Hi All,

I am wondering that if we create 10 jobs that each one inserts 100 rows to a specific table. Will it be parallel? In other words, please correct me if I am wrong, when a job starts Oracle doesn't wait it until it finish. It will execute the others respectively, right? If this logic is true, so we can use DBMS_JOB or DBMS_SCHEDULER for parallel processing?

Thanks in advance.
This post has been answered by GregV on Jun 11 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 9 2015
Added on Jun 10 2015
11 comments
1,362 views