V$SESSION_OBJECT_CACHE
displays object cache statistics for the current user session on the local server (instance).
Column | Datatype | Description |
---|---|---|
|
|
Number of object pins or look-ups in the cache |
|
|
Number of object pins that found the object already in the cache |
|
|
Number of object pins that found the object already in the cache and in the desired state (thus, not requiring refresh from the database) |
|
|
Ratio of |
|
|
Ratio of |
|
|
Number of objects in the cache that were refreshed with a new value from the database |
|
|
Number of times the whole cache (all objects) were refreshed |
|
|
Number of objects in the cache that were flushed to the database |
|
|
Number of times the whole cache (all objects) were flushed to the database |
|
|
Number of times the cache was shrunk to the optimal size |
|
|
Number of objects currently cached |
|
|
Number of objects currently pinned |
|
|
Current size of the cache (in bytes) |
|
|
Optimal size of the cache (in bytes) |
|
|
Maximum size of the cache (in bytes) |
|
|
The ID of the container to which the data pertains. Possible values include:
|