Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: buffer busy waits for data block
Buffer busy waits ratio=(buffer busy waits)/(consistent gets + db block
gets)
If this ration is greater than 5% there is a problem. As usual, this problem
indicates
a wait for a rollback segment buffer. You should add more rollback segments
until
"undo header waits" is 0 in V$WAITSTAT. Also this problem can point to low
value of
"free lists" option (if you have multiple processors).
Torsten Kleinblotekamp wrote <36C00480.7E11F9C5_at_it-mannesmann.de> ...
>I think we've got to many buffer busy wait. The database-buffer hitratio
>is still o.k. How can I fix this problem?
>
>Thanks
>
Received on Tue Feb 09 1999 - 13:54:58 CST