The system table SYSINFO.SPINLOCKPOOLSTATISTICS describes pooled internal lock mechanisms and actions performed using them since the last start of the database.
SPINLOCKPOOLNAME |
CHAR(40) |
Name of the spin lock pool |
AVGLOCKCOUNT |
FIXED(20) |
Number of attempts to get the spin lock – average value within the pool |
MINLOCKCOUNT |
FIXED(20) |
Number of attempts to get the spin lock – minimum value within the pool |
MAXLOCKCOUNT |
FIXED(20) |
Number of attempts to get the spin lock – maximum value within the pool |
AVGCOLLISIONCOUNT |
FIXED(20) |
Number of failed attempts to get the spin lock – average value within the pool |
MINCOLLISIONCOUNT |
FIXED(20) |
Number of failed attempts to get the spin lock – minimum value within the pool |
MAXCOLLISIONCOUNT |
FIXED(20) |
Number of failed attempts to get the spin lock – maximum value within the pool |
AVGTOTALSPINLOOPCOUNT |
FIXED(20) |
Number of attempts to get the spin lock without prior release of the CPU – average value within the pool |
MINTOTALSPINLOOPCOUNT |
FIXED(20) |
Number of attempts to get the spin lock without prior release of the CPU – minimum value within the pool |
MAXTOTALSPINLOOPCOUNT |
FIXED(20) |
Number of attempts to get the spin lock without prior release of the CPU – maximum value within the pool |
AVGTOTALYIELDLOOPCOUNT |
FIXED(20) |
Number of attempts to get the spin lock after prior release of the CPU – average value within the pool |
MINTOTALYIELDLOOPCOUNT |
FIXED(20) |
Number of attempts to get the spin lock after prior release of the CPU – minimum value within the pool |
MAXTOTALYIELDLOOPCOUNT |
FIXED(20) |
Number of attempts to get the spin lock after prior release of the CPU – maximum value within the pool |
AVGMAXSPINLOOPCOUNT |
FIXED(20) |
Maximum number of attempts to get the spin lock without prior release of the CPU – average value within the pool |
MINMAXSPINLOOPCOUNT |
FIXED(20) |
Maximum number of attempts to get the spin lock without prior release of the CPU – minimum value within the pool |
MAXMAXSPINLOOPCOUNT |
FIXED(20) |
Maximum number of attempts to get the spin lock without prior release of the CPU – maximum value within the pool |
AVGMAXYIELDLOOPCOUNT |
FIXED(20) |
Maximum number of attempts to get the spin lock after prior release of the CPU – average value within the pool |
MINMAXYIELDLOOPCOUNT |
FIXED(20) |
Maximum number of attempts to get the spin lock after prior release of the CPU – minimum value within the pool |
MAXMAXYIELDLOOPCOUNT |
FIXED(20) |
Maximum number of attempts to get the spin lock after prior release of the CPU – maximum value within the pool |