Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Instance Monitor - Any Good?
I'm having a similar experience with the buffer cache miss rate going as
high as 35% and also the sql lib cache miss rate ranging from 20 to 60%.
Yet using SQL, both show hit rates above 95% whenever I check.
I'd like to know what the descrepency is also
Jim Gregory
webbo <hughjanus_at_my-deja.com> wrote in message
news:7u2ba3$tmb$1_at_nnrp1.deja.com...
> Hi,
>
> Been evaluating Instance Monitor, from Quest Software, with mixed
> results. For example,
>
> Shows an alarm about Buffer Busy waits being a high percentage of non-
> idle waits, & advises that either freelists or rollback segments are
> insufficient.
>
> However, using trusty old SQL*Plus to query the data dictionary, I find
> Free List waits are 0, and the undo wiats are a fraction of a percent
> of the total of db block + consistent gets.
>
> So why the alarm?
>
> Am I missing something, or does this tool not work very well??
>
> Cheers
> Webbo
>
> --
> Webbo
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Oct 14 1999 - 08:19:27 CDT