-
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]
-
What are you trying to do?
Buffer hit ratio, library hit ratio, and dictionary hit ratio appear in the tuning material I have seen. You can get them by looking at v$sysstat, v$rowcache and v$librarycache.
Good luck.