Threshold of lock Escalation from Page to Table

 

When the number of locks on pages in the same table exceeds the lock escalation threshold from page to table, DBMaker will automatically escalate the lock to a table lock. When the number of locks on rows in the same table exceeds the lock escalation threshold from row to page, DBMaker will automatically escalate the lock to a page lock. This number specifies the Lock Escalation Threshold for escalating a page lock to a table lock. When the number of locks on pages in the same table exceeds the lock escalation threshold, DBMaker will automatically escalate the lock to a table lock. The default value is 50 pages.


Related topic:

Setting Cache and Control Options
Threshold of lock Escalation from Row to Table