SPINLOCKSTATISTICS
The system table SYSINFO.SPINLOCKSTATISTICS
contains
information on internal lock mechanisms since the last start of the database
system.
Structure
|
CHAR(40) |
Name of the spin lock |
|
FIXED(20) |
Number of attempts to get the spin lock |
|
FIXED(20) |
Number of failed attempts to get the spin lock |
|
FIXED(20) |
Number of attempts to get the spin lock without prior release of the CPU |
|
FIXED(20) |
Number of attempts to get the spin lock after prior release of the CPU |
|
FIXED(20) |
Maximum number of attempts to get the spin lock without prior release of the CPU |
|
FIXED(20) |
Maximum number of attempts to get the spin lock after prior release of the CPU |