The system table SYSINFO.REGIONSTATISTICS contains information about regions and their use since the database system was started.
REGIONNAME |
CHAR(16) |
Name of region |
REGIONID |
FIXED(10) |
ID of the region |
HOLDERTASKID |
FIXED(10) |
ID of the task holding this region |
REQUESTORCOUNT |
FIXED(10) |
Number of tasks waiting for the region |
ACCESSCOUNT |
FIXED(20) |
Number of accesses to this region |
SPINLOCKCOLLISIONCOUNT |
FIXED(20) |
Number of collisions with internal mechanisms during use of this region |
WAITCOUNT |
FIXED(20) |
Number of collisions that resulted in use of the queue for this region |
COLLISIONCOUNT |
FIXED(20) |
Number of collisions between the task holding the region and another task that is waiting for this region |
COLLISIONRATE |
FIXED(10) |
Number of accesses that led to collisions |