CATALOGCACHESTATISTICS

Definition

The system table CATALOGCACHESTATISTICS contains information about actions and the status of the catalog cache since the database system was started.

Structure

CATALOGCACHESTATISTICS

RELEASEMEMORYCOUNT

FIXED(20)

Number of objects removed from the catalog cache due to insufficient memory

ENTRYCOUNT

FIXED(10)

Number of objects currently in the catalog cache

MAXENTRYCOUNT

FIXED(10)

Maximum number of objects in the catalog cache at any time

ENTERLRU

FIXED(20)

Number of insertions into the LRU list

REMOVELRU

FIXED(20)

Number of deletions from the LRU list

INVALIDATECOUNT

FIXED(10)

Number of objects marked as invalid

LRUENTRYCOUNT

FIXED(10)

Number of entries currently stored in the LRU list

INVALIDHANDLECOUNT

FIXED(10)

Number of objects marked as invalid currently in the catalog cache

See also:

Glossary, Catalog Cache