Oracle9i Database Reference
Release 1 (9.0.1)

Part Number A90190-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Dynamic Performance (V$) Views, 162 of 211


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  


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback