Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: why different db cache hit ratios?
there was a post on oracle-l about 3-4 BCHRs. I dont know the differences.
BCHR is pretty useless.
"Frank van Bortel" <fbortel_at_nescape.net> wrote in message
news:bsaec2$9ak$2_at_news2.tilbu1.nb.home.nl...
> Ibrahim DOGAN wrote:
>
> > the calculation of db cache hit ratios using following methods produce
> > different results?
> >
> > 1- using v$sysstat:
> > SELECT 100*(1- ((p.value - l.value - d.value) / s.value)) "Buffer
> > Cache Hit Ratio"
> > FROM v$sysstat s, v$sysstat l, v$sysstat d, v$sysstat p
> > WHERE s.name = 'session logical reads'
> > AND d.name = 'physical reads direct'
> > AND l.name = 'physical reads direct (lob)'
> > AND p.name = 'physical reads';
> >
> >
> > 2- using v$buffer_pool_statistics
> >
> > select (1-(physical_reads/(db_block_gets+consistent_gets)))*100
> > cache_hit_ratio
> > from v$buffer_pool_statistics;
> >
> >
> > * So which v$ table has more accurate stats or more reliable ?
> >
> > Thanks,
> > i.d.
>
> Who cares about BDCHR - what platform and version are you anyway?
> --
> Merry Christmas and a Happy New Year,
> Frank van Bortel
>
Received on Tue Dec 23 2003 - 18:08:20 CST