This view displays similar information to the V$SESSION_CURSOR_CACHE
view except that this information is system wide.
See Also:
"V$SESSION_CURSOR_CACHE"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 |