Re: library cache hit ratio > 100%

looks like pins are negative.

Its V 8.1.7.4

SQL> select SUM(PINS),SUM(RELOADS) from v$librarycache;

 SUM(PINS)                   SUM(RELOADS)
----------                        ------------
-1.443E+09                  143954

...JIM... >>> Jared Still <jkstill_at_gmail.com> 3/14/05 3:12:37 PM >>> My guess is that reloads has gone negative.

Which version of Oracle?

Jared

On Mon, 14 Mar 2005 14:47:05 -0600, James Howerton <jhowerton_at_uabmc.edu> wrote:
> 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
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l