Show TOC

Object documentationREGIONSTATISTICS Locate this document in the navigation structure

 

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

Structure

REGIONSTATISTICS

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

More Information

Glossary, Critical Section

REGIONSTATISTICSRESET