Oracle® Database Reference 11g Release 2 (11.2) Part Number E25513-03 |
|
|
PDF · Mobi · ePub |
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 |