Skip to Main Content
  • Questions
  • Oracle locking a table while deleting set of rows

Breadcrumb

May 4th

Question and Answer

Chris Saxon

Thanks for the question, Madhusudhan.

Asked: September 12, 2018 - 9:30 pm UTC

Last updated: September 13, 2018 - 2:02 am UTC

Version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

Viewed 1000+ times

You Asked

I have 2 scripts running at the same time deleting different set of rows from same table. Would this cause any locking issues or contention? Please advise. Thank you very much.

and Connor said...

It depends.

The delete of the rows in its own right will never block assuming they are not touching the same rows.

However, if you have foreign key constraints back to parent tables, then you *might* get into trouble.

We'd need to see the DDL and the statements concerned in order to comment more.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Madhusudhan Gadikota, September 13, 2018 - 11:10 am UTC


More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database