The onstat -g spi command displays a list of the resources in the system where a wait was required to obtain a latch on a resource. During the wait, the thread will spin (or loop) trying to acquire the resource. The number of times a wait was required for the resource and the number of total loops performed are given.
Spin locks with waits: Num Waits Num Loops Avg Loop/Wait Name 11 14 1.27 vproc vp_lock, id = 1 1 1 1.00 vproc vp_lock, id = 7 1 1 1.00 tcb lock, tid = 5
|Num Waits||The number of times the resource had to be waited on due to another thread holding a latch on that resource.||Dec|
|Num Loops||The number of times a loop was performed to test for the release of the latch on the resource.||Dec||onstat -g spi|
|Avg Loop/Wait||The average number of loops that were performed for each wait.||Flt|
|Name||The name of the resource upon which a spin locking condition has existed.
lockfr The lock free list. The number after lockfr is the index into the lock free list array. lockhash The lock hash bucket. The field inside the brackets is the index into the lock hash bucket array. :bhash  The buffer hash bucket. The field before the colon is the buffer pool index; the field inside the brackets after bhash is the index into the buffer hash bucket array. :lru- The LRU latch. The field before the colon is the buffer pool index; the field after lru- identifies the buffer chain pairs that are being used. :bf The buffer latch. The field before the colon is the buffer pool index; the field inside the brackets after bf is the position of buffer in the buffer array. The next two fields are the partition number and the page header address in memory for the buffer in hex form.
|Str||onstat -g wmx|
To discuss how Oninit ® can assist please call on +1-913-674-0360 or alternatively just send an email specifying your requirements.