Package Cache Overflows


Snapshot Level
Database

Logical Data Grouping
dbase

Monitor Switch
Basic

Resettable

Yes

 
Event Type
Database

Logical Data Grouping
db_event

 
Element Name
Element Type

pkg_cache_num_overflows
counter

Description:  The number of times that the package cache overflowed the bounds of its allocated memory.

Usage:  Use this element with pkg_cache_size_top to determine whether the size of the package cache needs to be increased to avoid overflowing. Overflows of the package cache can cause unnecessary lock escalations, resulting in loss of concurrency, or out of memory errors from the other heaps allocated out of the database shared memory.