Re: free buffer waits

[George Schlossnagle]

Sounds like the write latency on your storage is high or you have an abusive. 'free buffer waits' is the db writer failing to flush it's cache fast enough to disk.

George

On Thursday, March 7, 2002, at 06:39 PM, Manytrees wrote:

Hello all,
�
Does anybody know what parameters I should be tuning/change to try & reduce the number of busy buffer waits.� I have a system which at times has over 15+session waiting on "free buffer waits".
�
The explanation that I have been able to find so far is that session are waiting on buffer to free up :)
�
Have a good night all,
�
Joel.

// George Schlossnagle
// Principal Consultant
// OmniTI, Inc http://www.omniti.com
// (c) 301.343.6422 (e) [EMAIL PROTECTED]
// 1024D/1100A5A0� 1370 F70A 9365 96C9 2F5E�56C2 B2B9 262F 1100 A5A0