The system table SYSINFO.CACHESTATISTICS contains information on accesses to caches since the last time the database instance was started.
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 (%) |
Evaluating System Tables, CACHESTATISTICS