Re: When does bufwaits get incremented ?

In article <33F9E9A6.7EE8@bloomberg.com>, "Art S. Kagel" <kagel@bloomberg.com> writes >tony edwards wrote: >> >> Hey, >> I've been trying to track down some information about when bufwaits is >> incremented. I found the following in the ODS Admin guide... > >If after a limited number of attempts to find an unlocked queue, no >free buffer has been found the thread will spin wait/sleep on the last >queue touched waiting for that particular queue to unlock. This is a >bufwait. > I talked to the instructor at Informix UK when I went on the Online 7 performance Tuning course. He contacted the USA but still could not find out EXACTLY what bufwaits meant. He did say that if bufwaits was too high then increasing the number of buffers would help (apparently this came from "the programmers in the USA who have access to the source.."). Where did you here this? >Art S. Kagel -- David Williams