Spinlock Activity

Spinlock activity

Columns

Name Description
Inst ID Instance ID; 0 = non-CE
Spinlock Name Spinlock name
Count Number of spinlocks in the array associated with the spinlock name. For example, a partitioned data cache with 16 partitions might have 16 spinlocks in the array.
Contention % Contention %, in interval
Grabs / Sec Number of grabs per second, in interval
Spins / Sec Number of spins per second, in interval
Waits / Sec Number of waits per second, in interval
Current Grabs Delta number of grabs
Overall Grabs Total number of grabs, since collection started
Current Spins Delta number of spins
Overall Spins Total number of spins, since collection started
Current Waits Delta number of waits
Overall Waits Total number of waits, since collection started
Current Contention Contention %, in interval
Overall Contention Contention %, since collection started
Current Spins per Wait Delta number of spins / delta number of waits
Overall Spins per Wait Spins / Waits, since collection started

Entity Requirements

Attributes: None
Minimum database version: 12.5.0.3

Sample