Lock escalation occurs when database locks are raised to higher “levels”, because a particular database session places an increasing number of locks on the same types of database objects.
Yes, lock escalation is built into RDBMS’s, and they determine when it’s performed.
ALTER TABLE some_table SET (LOCK_ESCALATION = DISABLE)
ALTER TABLE some_table SET (LOCK_ESCALATION = TABLE)
What is the point of lock escalation? When would lock escalation be necessary?
Because of the fact that having small amounts of data constantly being locked and unlocked can cause some significant overhead, performing lock escalation – and raising the lock to a higher level – can really improve database performance. For example, if we have many locks on rows from the same table, it might just make sense to escalate the lock to the table level, and this could improve performance. So, remember that lock escalation exists to improve performance.
Read full article from Lock Escalation
Yes, lock escalation is built into RDBMS’s, and they determine when it’s performed.
ALTER TABLE some_table SET (LOCK_ESCALATION = DISABLE)
ALTER TABLE some_table SET (LOCK_ESCALATION = TABLE)
What is the point of lock escalation? When would lock escalation be necessary?
Because of the fact that having small amounts of data constantly being locked and unlocked can cause some significant overhead, performing lock escalation – and raising the lock to a higher level – can really improve database performance. For example, if we have many locks on rows from the same table, it might just make sense to escalate the lock to the table level, and this could improve performance. So, remember that lock escalation exists to improve performance.
Read full article from Lock Escalation
No comments:
Post a Comment