Calculating Free Buffer Wait [message #183208] |
Wed, 19 July 2006 23:18 |
pallaviyd
Messages: 9 Registered: June 2006
|
Junior Member |
|
|
Hi,
Currently we are calculating Free Buffer Wait with following formula:
SQL> select NAME,VALUE from V$SYSSTAT where NAME in ('free buffer inspected', 'free buffer requested');
NAME VALUE
-------------------------------- ------------
free buffer requested 3194990
free buffer inspected 3138511
% Free Buffer Wait=
(free buffer inspected*100)/free buffer requested
Sometimes its going far beyond 100%(even upto >150 also).
Is this formula correct?
Can this be considered as a normal behavior?
Please do let me know.
Thanks,
Pallavi.
|
|
|