Summary information |
|
|---|---|
Default value |
10 |
Range of values |
1–2147483647 |
Status |
Dynamic |
Display level |
Comprehensive |
Required role |
System Administrator |
For Adaptive Servers running with multiple engines, partition spinlock ratio sets the number of rows in the internal partition caches that are protected by one spinlock.
Adaptive Server manages access to table partitions using internal partition groups, each of which contains partition caches. Each partition cache stores information about a partition (for example, the last page of the partition) that processes must use when accessing that partition.
By default, Adaptive Server systems are configured with partition spinlock ratio set to 10, or 1 spinlock for every 10 partition caches. Decreasing the value of partition spinlock ratio may have little impact on the performance of Adaptive Server. The default setting is correct for most servers.
For more information about configuring spinlock ratios, see “Configuring spinlock ratio parameters”.
