CACHESTATISTICS

Definition

The system table 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 (%)

See also:

Evaluating System Tables, CACHESTATISTICS