CODEWITHSUNDEEP
sqloracle-databaseconcurrency
ironhide391
ironhide391

Reputation: 595

Are insert in Oracle sequential

I have a table in Oracle. I am creating multiple Batch jobs. Each Batch job is inserting some number of records in the table.

I wanted to know whether there insert statements are sequential executed ?

Upvotes: 0

Views: 111

Answers (1)

Seyran
Seyran

Reputation: 721

In particular job, if it's runs in one transaction answer is 'YES', but if you want to find out sequence through all jobs , which starts same time, it all depends of particular situation and you jobs implementation. For example if we have 2 jobs and one them starts earlier then other, but first one needs more time to collect data then we can't say that first job inserts will be done earlier then second. There are many factors which affect to order of records insert. So if it's critical for you to control order then you should implement consistency yourself, using timestamp checks or object locks.

Upvotes: 1

Related Questions