> What does 'Total Buffer Requests' mean if it is a negative value? And 'Cache
> Hit Pct' is zero?
> Thanks.
>
> Regards,
> Phillip Guan
There is a counter that is incremented for each buffer request. If
you let your server run for a very long time without doing a "reset
bufpool", the counter eventually reaches the point where adding 1
causes the leftmost bit to get turned on. This bit is normally used
to indicate a negative number, so the value displayed on the query
command is shown as negative.
As the counter continues to be incremented, you will notice that
the displayed value becomes a smaller negative number. After
another long time, the counter will go from -1 to 0 to 1, and so on.
My guess is that the % calculations go crazy when the counter is
negative, so the value displayed is zero.
Just issue a "reset bufpool" to reset the counter to zero, and the
displays will start making sense again.
Mike Hull mhull AT uottawa DOT ca
Systems and Automation Analyst 613-562-5800 x 4587
Computer Centre / 136 Jean-Jacques Lussier Room 543
University of Ottawa / Ottawa, Ontario / Canada K1N 6N5
|