Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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