Object documentationSPINLOCKSTATISTICS Locate this document in the navigation structure

 

The system table SYSINFO.SPINLOCKSTATISTICS contains information on internal lock mechanisms since the last start of the database system.

Structure

SPINLOCKSTATISTICS

NAME

CHAR(40)

Name of the spin lock

LOCKCOUNT

FIXED(20)

Number of attempts to get the spin lock

COLLISIONCOUNT

FIXED(20)

Number of failed attempts to get the spin lock

SPINLOOPCOUNT

FIXED(20)

Number of attempts to get the spin lock without prior release of the CPU

YIELDLOOPCOUNT

FIXED(20)

Number of attempts to get the spin lock after prior release of the CPU

MAXSPINLOOPCOUNT

FIXED(20)

Maximum number of attempts to get the spin lock without prior release of the CPU

MAXYIELDLOOPCOUNT

FIXED(20)

Maximum number of attempts to get the spin lock after prior release of the CPU

More Information

SPINLOCKSTATISTICSRESET