The system table CACHESTATISTICS contains information on accesses to caches since the last time the database instance was started.
CACHESTATISTICS
CHAR(20) |
Name of the cache |
|
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) |
Hit rate (successful cache accesses as a percentage of total cache accesses) |