Re: Buffer cache hit very low...!!!
- From: David Sharples <davidsharples@xxxxxxxxx>
- To: chiragdba@xxxxxxxxx
- Date: Tue, 13 Sep 2005 20:02:28 +0100
firstly you are probably using db_cache_size new in 9i.
Also why are you still using ratios? that went out with the dinosaurs. Its
all about the wait interface now, find the problem which are causing your
biggest waits and fix them
generally ignore the ratios
On 9/13/05, Chirag DBA <chiragdba@xxxxxxxxx> wrote:
>
> Hi Team,
> My OEM shows buffer cache hit ratio as 28% and library cache as 99%.
> Another query shows different results for buffer cache.
>
> And my db_block_buffers show value as 0.
>
- References:
- Buffer cache hit very low...!!!
- From: Chirag DBA
Other related posts:
- » Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » RE: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » RE: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- » Re: Buffer cache hit very low...!!!
- Buffer cache hit very low...!!!
- From: Chirag DBA