Dynamic Performance (V$) Views, 141 of 179

V$SESSION_OBJECT_CACHE

This view displays object cache statistics for the current user session on the local server (instance).

Column	Datatype	Description
`PINS`	`NUMBER`	Number of object pins or look-ups in the cache
`HITS`	`NUMBER`	Number of object pins that found the object already in the cache
`TRUE_HITS`	`NUMBER`	Number of object pins that found the object already in the cache and in the desired state (thus, not requiring refresh from the database)
`HIT_RATIO`	`NUMBER`	The ratio of HITS/PINS
`TRUE_HIT_RATIO`	`NUMBER`	The ratio of TRUE_HITS/PINS
`OBJECT_REFRESHES`	`NUMBER`	Number of objects in the cache that were refreshed with a new value from the database
`CACHE_REFRESHES`	`NUMBER`	Number of times the whole cache (all objects) were refreshed
`OBJECT_FLUSHES`	`NUMBER`	Number of objects in the cache that were flushed to the database
`CACHE_FLUSHES`	`NUMBER`	Number of times the whole cache (all objects) were flushed to the database
`CACHE_SHRINKS`	`NUMBER`	Number of times the cache was shrunk to the optimal size
`CACHED_OBJECTS`	`NUMBER`	Number of objects currently cached
`PINNED_OBJECTS`	`NUMBER`	Number of objects currently pinned
`CACHE_SIZE`	`NUMBER`	Current size of the cache in bytes
`OPTIMAL_SIZE`	`NUMBER`	Optimal size of the cache in bytes
`MAXIMUM_SIZE`	`NUMBER`	Maximum size of the cache in bytes