Re: High numbers of buffer waits in OnLine

David Williams wrote: <SNIPedySNIP> > First apologies for the typo above - f and g are next to one another > on the keyboard! > > Buffer wait does mean that the process is waiting for a buffer which > is in use by another process. However they do not have to be accessing > the same data. What if you want to read in a page from disk and all > the buffers are already in use? i.e. the page is not already in the > buffers but all the buffers are in use so you have to wait for a > buffer to become free. This would show up as foreground writes. Which are VERY undesirable! > This was one of the few questions I raised when I went on the OnLine > Performance Tuning course last June. Did they mention that 'bugger waits' (sic) was when you are waiting for users to stop hogging resources? :^) Cheers, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za| | | |Email: marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+