The time when the statement or section was
inserted into the cache. For dynamic sql snapshots this represents
the time when the statement entered the cache. For MON_GET_PKG_CACHE_STMT,
MON_GET_PKG_CACHE_STMT_DETAILS and the package cache event monitor,
the value is more granular and represents the time when an individual
section for this statement was inserted into the cache.
Table 2. Snapshot Monitoring InformationSnapshot Level |
Logical Data Grouping |
Monitor Switch |
Dynamic SQL |
dynsql |
Basic |
Table 3. Event
Monitoring InformationEvent Type |
Logical Data Grouping |
Monitor Switch |
Package cache |
- |
COLLECT BASE DATA |
Usage
This element specifies the time when
the statement was inserted into the cache. It can be used to estimate
the lifetime of a statement in the cache.