MONITOR_CACHES

Definition

This monitor system table MONITOR_CACHES contains information about executed operations on the various caches.

Structure

DESCRIPTION Column

Value

Explanation

Data cache accesses

Number of accesses to pages in the data cache (number of accesses to data pages and pages with rollback information)

Data cache accesses successful

Number of successful accesses to pages in the data cache

Data cache accesses unsuccessful

Number of unsuccessful accesses to pages in the data cache

Data cache hit rate (%)

Percentage of successful accesses to data pages in the data cache

Catalog cache accesses

Number of accesses to the session-specific catalog cache

Catalog cache accesses successful

Number of successful accesses to the session-specific catalog cache

Catalog cache accesses unsuccessful

Number of unsuccessful accesses to the session-specific catalog cache

Catalog cache hit rate (%)

Percentage of successful accesses to the session-specific catalog cache

Sequence cache accesses

Number of accesses to the sequence cache

Sequence cache accesses successful

Number of successful accesses to the sequence cache

Sequence cache accesses unsuccessful

Number of unsuccessful accesses to the sequence cache

Sequence cache hit rate (%)

Percentage of successful accesses to the sequence cache

Data cache sqlpage accesses

Number of accesses to data pages in the data cache

Data cache sqlpage accesses successful

Number of successful accesses to data pages in the data cache

Data cache sqlpage accesses unsuccessful

Number of unsuccessful accesses to data pages in the data cache

Data cache sqlpage hit rate(%)

Percentage of successful accesses to data pages in the data cache

Data history/undo accesses

Number of accesses to pages with rollback information or information for consistent reading in the data cache

Data history/undo accesses successful

Number of successful accesses to pages with rollback information or information for consistent reading in the data cache

Data history/undo accesses unsuccessful

Number of unsuccessful accesses to pages with rollback information or information for consistent reading in the data cache

Data history/undo hit rate (%)

Percentage of successful accesses to pages with rollback information or information for consistent reading in the data cache

The system table MONITOR_CACHES exists only to enable compatibility with older database versions. Instead of the system table MONITOR_CACHES, use the system table CACHESTATISTICS.

See also:

MONITOR