REGIONSTATISTICS

Definition

The system table REGIONSTATISTICS contains information about regions and their use since the database system was started.

Structure

REGIONSTATISTICS

REGIONNAME

CHAR(16)

Name of the 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

See also:

Glossary, Critical Section

REGIONSTATISTICSRESET