Re: What is good number for bufwaits?

Art S. Kagel <kagel@bloomberg.com> wrote in article <3558A5EA.1398@bloomberg.com>... ...snip... > 2) More LRUS == fewer bufwaits. This is critical! The more LRUS the > better. Avoid LRUS=64 and LRUS=96 as there seems to be a bug in the > LRU hash algorithm that causes bufwaits to skyrocket at these > particular values (and LRUS=128 triggers a harmless but scary bug at > engine startup that complains about zero length Physical and Logical > log files). I know that the following values are fine: 4, 16, 32, 127. > Art, Why does more LRUs == fewer bufwaits? If you've got a fixed number of buffers how does the division of them to a number of LRU queues speed buffer access? Either way, you're still waiting for a buffer to free up? Thanks. David -- David Samson, Senior Database Researcher dsamson@ndsisrael.com NDS Technologies Israel Ltd. +972 2-589-4529 PO Box 23012 Fax: +972 2-589-4578 Jerusalem, Israel Cellular: +972 51 287 481