what are the bench marks for hit ratio
with using of select * from v$system_cursor_cache;
OPENS HITS HIT_RATIO
---------- ---------- ----------
339791 339793 1.00000589
with using of select * from v$session_cursor_cache;
MAXIMUM COUNT OPENED_ONCE OPEN OPENS HITS HIT_RATIO
---------- ---------- ----------- ---------- ---------- ---------- ----------
2500 0 0 0 0 0 1
what is this mean ??
thanks in advance
sri
[Edited by sripalli on 08-20-2001 at 09:16 PM]