| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> library cache hit ratio > 100%
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...
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 14 2005 - 15:50:54 CST
 |
 |