Catalog Cache Heap Full



Snapshot Level
Database
Application


Logical Data Grouping
dbase
appl


Monitor Switch
Basic
Basic


Resettable


Yes

 

Event Type
Database
Connection


Logical Data Grouping
db_event
conn_event

 

Element Name
Element Type



cat_cache_heap_full
counter

 

Description:  The number of times that an insert into the catalog cache failed due to a heap-full condition in the database heap.

Usage:  The catalog cache draws its storage dynamically from the database heap and even if the cache storage has not reached its limit, inserts into the catalog cache may fail due to a lack of space in the database heap.

If the catalog cache heap full count is not zero, then this insert failure condition can be corrected by increasing the database heap size or reducing the catalog cache size.