(Multiprocessing systems only) open object spinlock ratio specifies the number of object descriptors that are protected by one spinlock.
|
Summary Information |
|
|---|---|
|
Default value |
100 |
|
Range of values |
1–2147483647 |
|
Status |
Dynamic |
|
Display level |
Comprehensive |
|
Required role |
System administrator |
|
Configuration group |
Meta-Data Cache |
SAP ASE uses a spinlock to protect an object descriptor, since more than one process can access the contents of the object descriptor.
The default value for this parameter is 100; 1 spinlock for each 100 object descriptors configured for your server. If your server is configured with only one engine, SAP ASE sets only 1 object descriptor spinlock, regardless of the number of object descriptors.
If one spinlock is shared by too many object descriptors, it causes spinlock contention. Use sp_sysmon to get a report on spinlock contention. See the Performance and Tuning Series: Monitoring SAP Adaptive Server with sp_sysmon.
If sp_sysmon output indicates an object descriptor spinlock contention of more than 3 percent, try decreasing the value of the open object spinlock ratio parameter.
See System Administration Guide: Volume 2 > Managing Mulitprocessor Servers.