Catalog Cache Inserts



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_inserts
counter

 

Description:  The number of times that the system tried to insert table descriptor information into the catalog cache.

Usage:  Table descriptor information is usually inserted into the cache following a failed lookup to the catalog cache while processing a table, view, or alias reference in an SQL statement. The catalog cache inserts value includes attempts to insert table descriptor information that fail due to catalog cache overflow and heap full conditions.

See Catalog Cache Lookups for more catalog cache information.