address lock spinlock ratio sets the number of rows in the internal address locks hash table that are protected by one spinlock for SAP ASEs running with multiple engines.
|
Summary Information |
|
|---|---|
|
Default value |
100 |
|
Range of values |
1–2147483647 |
|
Status |
Static |
|
Display level |
Comprehensive |
|
Required role |
System administrator |
|
Configuration group |
Lock Manager |
SAP ASE manages the acquiring and releasing of address locks using an internal hash table with 1031 rows (known as hash buckets). This table can use one or more spinlocks to serialize access between processes running on different engines.
The default value for address lock spinlock ratio defines 11 spinlocks for the address locks hash table. The first 10 spinlocks protect 100 rows each, and the eleventh spinlock protects the remaining 31 rows. If you specify a value of 1031 or greater for address lock spinlock ratio, SAP ASE uses only 1 spinlock for the entire table.