Re: library cache hit ratio > 100%

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