SHARELOCKSTATISTICS
The system table SYSINFO.SHARELOCKSTATISTICS describes critical sections and their use since the last start of the database.
|
SHARELOCKADDRESS |
CHAR(20) |
Address in memory |
|
SPINLOCKPOOLNAME |
CHAR(40) |
Name of the spin lock pool used |
|
SHARELOCKINDEX |
FIXED(20) |
Index in a group of share licks that use the spin lock pool |
|
EXCLUSIVEACCESSCOUNT |
FIXED(20) |
Number of exclusive accesses to this critical section |
|
NONEXCLUSIVEACCESSCOUNT |
FIXED(20) |
Number of non-exclusive accesses to this critical section |
|
COLLISIONCOUNT |
FIXED(20) |
Number of collisions between a task that is occupying the critical section and another task that is requesting the critical section |
|
WAITCOUNT |
FIXED(20) |
Number of tasks waiting for access to the critical section |
|
SPINLOCKCOLLISIONCOUNT |
FIXED(20) |
Number of task collisions in the management of the critical section |
|
LASTENTEREDTASKID |
FIXED(10) |
Identification of the task that last gained access to the share lock |
SHARELOCKSTATISTICSRESET, SHARELOCKWAITINGTASKS, SHARELOCKINFORMATION
Concepts of the Database System, Working Memory Areas
Glossary, Critical Section