V$SYSTEM_CURSOR_CACHE displays system wide information on cursor usage.
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 an open cursor was found divided by the number of times a cursor was sought |