Re: free buffer waits

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) george_at_omniti.com
// 1024D/1100A5A0  1370 F70A 9365 96C9 2F5E 56C2 B2B9 262F 1100 A5A0

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: George Schlossnagle
  INET: george_at_omniti.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).