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.