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.