0

Is there a way where I can run DML statements on different tables in parallel on a Oracle database?

By in parallel I mean if I have two insert statements on table A and table B, they should both be executed at the same time (not sequentially).

Improve this question
4
  • 2
    Run them from two different connections Commented Jul 5, 2019 at 7:11
  • If It is possible, Try INSERT ALL or INSERT FIRST Commented Jul 5, 2019 at 7:21
  • @Prathamesh Do you mean the exact same statement, like in the duplicate question, or two different statements run concurrently? I have a feeling this question was incorrectly marked as a duplicate - let me know and I'll raise a flag if necessary. Commented Jul 6, 2019 at 17:06
  • @Jon Heller Two different tables with two different statements inserting concurrently. Commented Jul 8, 2019 at 17:09
Related questions
3
I want to run two or more procedures in parallel
4
How to execute oracle java stored procedure in parallel
0
Parallel Execution of Stored Procedure in Oracle
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.