|
Snapshot Level Database |
Logical Data Grouping dbase |
Monitor Switch Basic |
|
Resettable |
No | |
|
Event Type Database |
Logical Data Grouping db_event | |
|
Element Name Element Type |
pkg_cache_size_top water mark | |
Description: The largest size reached by the package cache.
Usage: This element indicates the maximum number of bytes the package cache required for the workload run against the database since it was activated.
If the package cache overflowed, then this element contains the largest size reached by the package cache during the overflow. Check Package Cache Overflows to determine if such a condition occurred.
When the package cache overflows, memory is temporarily borrowed from other entities in database shared memory (for example, lock list or database heap). This can result in memory shortage errors from these entities or performance degradation from concurrency reduction due to unnecessary lock escalations. You can determine the minimum size of the package cache required by your workload by:
maximum package cache size / 4096
Rounding the result up to a whole number, indicates the minimum number of 4K pages required by the package cache to avoid overflow.