Oracle® Database Reference 11g Release 2 (11.2) Part Number E10820-02 |
|
|
View PDF |
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 |