Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
This view displays similar information to the V$SESSION_CURSOR_CACHE
view except that this information is system wide.
Column | Datatype | Description |
---|---|---|
OPENS |
NUMBER |
Cumulative total of cursor opens |
HITS |
NUMBER |
Cumulative total of cursor open hits |
HIT_RATIO |
NUMBER |
Ratio of the number of times you found an open cursor divided by the number of times you looked for a cursor |