LOCKLIST indicates the amount of storage that is allocated to the lock list.
LOCKLIST表明分配给锁列表的存储容量。
This parameter indicates the amount of storage that is allocated to the lock list.
该参数表示分配给锁列表的存储器大小。
For example, the lock list is a memory pool that belongs to the database Shared memory set.
例如,lock list是属于数据库共享内存集的一个内存池。
If not, lock escalation continues until the percentage of the lock list held is below the value of MAXLOCKS.
否则,锁升级就会一直进行,直到所持有的锁列表百分比低于MAXLOCKS。
There is one lock list per database, and it contains the locks held by all applications concurrently connected to the database.
每个数据库都有一个锁列表,锁列表包含了并发连接到该数据库的所有应用程序所持有的锁。
MAXLOCKS defines a percentage of the lock list held by an application that must be filled before the database manager performs lock escalation.
MAXLOCKS定义了应用程序持有的锁列表的百分比,在数据库管理器执行锁升级之前必须填充该锁列表。
This parameter defines a percentage of the lock list held by an application that must be filled before the database manager performs escalation.
该参数定义数据库管理器执行升级之前必须填入的应用程序所占有锁列表的百分比。
The database manager determines which locks to escalate by looking through the lock list for the application and finding the table with the most row locks.
数据库管理器通过查看应用程序的锁列表并查找行锁最多的表,来决定对哪些锁进行升级。
You can increase MAXLOCKS if only a few applications run concurrently, because there will not be a lot of contention for the lock list space under these conditions.
如果只有几个应用程序并发地运行,则可以增大 MAXLOCKS,因为在这些条件下锁列表空间中不会有太多争用。
When the number of locks held by any one application reaches this percentage of the total lock list size, lock escalation occurs for the locks held by that application.
当任何一个应用程序所持有的锁数量达到整个锁列表大小的这个百分比时,对该应用程序所持有的锁进行锁升级。
The locking problems normally indicate some fairly significant concurrency problems in the application that should be dealt with before the lock list parameter is increased.
锁定问题通常表明应用程序中存在一些相当严重的并发性问题,在增大锁列表参数的值之前应当解决这些问题。
The locking problems normally indicate some fairly significant concurrency problems in the application that should be dealt with before the lock list parameter is increased.
锁定问题通常表明应用程序中存在一些相当严重的并发性问题,在增大锁列表参数的值之前应当解决这些问题。
应用推荐