library cache hit ratio > 100%
- From: "James Howerton" <jhowerton@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 14 Mar 2005 14:47:05 -0600
DBA's,
Has anyone seen library cache hit ratio > 100% ??? This is a very busy
production database, it is usually < 97 % ( I don't tune by hit ratios
I'm just curious).
SQL> select SUM(PINS)/(SUM(PINS)+SUM(RELOADS))*100
from v$librarycache;
Library Hit Ratio
--------------------------
100.009799
1 row selected.
TIA
...JIM...
--
//www.freelists.org/webpage/oracle-l
Other related posts:
