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.