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, as well as performance degradation.