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