| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-03 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-03 |
|
|
View PDF |
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 |
