CACHESTATISTICS 
Definition
The system table CACHESTATISTICS contains information on accesses to caches since the last time the database instance was started.
Structure
CACHESTATISTICS
FIXED(10) |
ID of the database session if the corresponding cache is session-specific; otherwise NULL. |
|
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 (%) |
See also:
Evaluating System Tables, CACHESTATISTICS