Object documentationCATALOGCACHESTATISTICS Locate this document in the navigation structure

 

The system table SYSINFO.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

DDLINVALIDATECOUNT

FIXED(10)

Number of objects marked as invalid because a DDL statement leads to inconsistencies

TIMEOUTINVALIDATECOUNT

FIXED(10)

Number of objects marked as invalid due to a timeout

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

More Information

Glossary, Catalog Cache