Package 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



pkg_cache_inserts
counter

 

Description:  The total number of times that a requested section was not available for use and had to be loaded into the package cache. This count includes any implicit prepares performed by the system.

Usage:  In conjunction with "Package Cache Lookups", you can calculate the package cache hit ratio using the following formula:

 
    1 - (Package Cache Inserts / Package Cache Lookups)

See Package Cache Lookups for information on using this element.