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