CODEWITHSUNDEEP
oracle-database
Amitabh
Amitabh

Reputation: 61197

What is row locking and chaining in Oracle?

What is row locking and chaining in Oracle and what is its impact on performance?

Upvotes: 2

Views: 548

Answers (1)

Vincent Malgrat
Vincent Malgrat

Reputation: 67722

Row locking and Row chaining are two entirely different concepts.

  • Row Locking is a mechanism that enables multiple users to modify the same table in a reliable, consistent fashion. It has no impact on performance since you can't disable it.
  • Row Chaining is when a row is too large to fit in a single data block and is split over two or more blocks. Having very large rows may impact performance. Basically Oracle will have to visit more blocks to reconstruct each chained row. In particular, this will add IOs on ACCESS BY ROWID operations.

Upvotes: 8

Related Questions