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_at_gmail.com> 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.
>
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 13 2005 - 14:10:15 CDT
