REGIONSTATISTICS
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 |
Glossary, Critical Section