The system table CATALOGCACHESTATISTICS contains information about actions and the status of the catalog cache since the database system was started.
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