首页 >  Term: lock escalation
lock escalation

(1) The response that occurs when the number of locks issued for one agent exceeds the limit specified in the database configuration; the limit is defined by the maxlocks configuration parameter. During a lock escalation, locks are freed by converting multiple locks on rows of a table into one lock on a table. This process is repeated until the limit is no longer exceeded.
(2) The promotion of a lock from a row, page, or LOB lock to a table space lock because the number of page locks that are concurrently held on a given resource exceeds a preset limit.

0 0

创建者

  • Peteh
  •  (V.I.P) 14225 分数
  • 100% positive feedback
© 2025 CSOFT International, Ltd.