Entering content frame

Object documentation SPINLOCKPOOLSTATISTICS Locate the document in the library structure

Definition

The system table SPINLOCKPOOLSTATISTICS describes pooled internal lock mechanisms and actions performed using them since the last start of the database instance.

Structure

SPINLOCKPOOLSTATISTICS

SPINLOCKPOOLNAME

CHAR(40)

Name of the spin lock pool

MAXLOCKCOUNT

FIXED(20)

Number of attempts to get the spin lock – maximum value within the pool ­ 

MINLOCKCOUNT

FIXED(20)

Number of attempts to get the spin lock – minimum value within the pool ­ 

AVGLOCKCOUNT

FIXED(20)

Number of attempts to get the spin lock – average value within the pool ­ 

MAXCOLLISIONCOUNT

FIXED(20)

Number of failed attempts to get the spin lock – maximum value within the pool ­ 

MINCOLLISIONCOUNT

FIXED(20)

Number of failed attempts to get the spin lock – minimum value within the pool ­ 

AVGCOLLISIONCOUNT

FIXED(20)

Number of failed attempts to get the spin lock – average 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 ­ 

MINTOTALSPINLOOPCOUNT

FIXED(20)

Number of attempts to get the spin lock without prior release of the CPU – minimum 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 ­ 

MAXTOTALYIELDLOOPCOUNT

FIXED(20)

Number of attempts to get the spin lock after prior release of the CPU – maximum 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 ­ 

AVGTOTALYIELDLOOPCOUNT

FIXED(20)

Number of attempts to get the spin lock after prior release of the CPU – average 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 ­ 

MINMAXSPINLOOPCOUNT

FIXED(20)

Maximum number of attempts to get the spin lock without prior release of the CPU – minimum 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 ­ 

MAXMAXYIELDLOOPCOUNT

FIXED(20)

Maximum number of attempts to get the spin lock after prior release of the CPU – maximum 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 ­ 

AVGMAXYIELDLOOPCOUNT

FIXED(20)

Maximum number of attempts to get the spin lock after prior release of the CPU – average value within the pool ­ 

See also:

SPINLOCKPOOLSTATISTICSRESET

 

Leaving content frame