Object documentationCACHESTATISTICS Locate this document in the navigation structure

 

The system table SYSINFO.CACHESTATISTICS contains information on accesses to caches since the last time the database instance was started.

Structure

CACHESTATISTICS

SESSIONID

FIXED(10)

ID of the database session if the corresponding cache is session-specific; otherwise NULL.

NAME

CHAR(20)

Cache name

ACCESSCOUNT

FIXED(20)

Number of accesses to the cache

SUCCESSFULACCESSCOUNT

FIXED(20)

Number of successful accesses to the cache

UNSUCCESSFULACCESSCOUNT

FIXED(20)

Number of unsuccessful accesses to the cache

HITRATE

FIXED(3)

Percentage of successful accesses to the cache (%)

More Information

Evaluating System Tables, CACHESTATISTICS