Re: library cache hit ratio > 100%
- From: Jared Still <jkstill@xxxxxxxxx>
- To: jhowerton@xxxxxxxxx
- Date: Mon, 14 Mar 2005 13:12:37 -0800
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@xxxxxxxxx> 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...
> --
> //www.freelists.org/webpage/oracle-l
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
//www.freelists.org/webpage/oracle-l
Other related posts:
