The system table READERWRITERLOCKSTATISTICS describes critical sections and their use since the last start of the database instance.
READERWRITERLOCKSTATISTICS
READERWRITERLOCKADDRESS |
CHAR(20) |
Address in memory |
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 |
See also:
READERWRITERLOCKSTATISTICSRESET