> 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