Dynamic Performance (V$) Views, 162 of 179

V$SYSTEM_CURSOR_CACHE

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

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