RE: lchwaits, read aheads

Posted in 1997

tony edwards — 13 Sep 1997 20:08:18 -0400 — source: Informix-list mailing list archive (1991-1998)

The simple guide to tuning RA pages... 4 - (3 + 2 + 1) = < 2% & > 0.5% of 4 The explanation.... Add ixda-RA + idx-RA + da-RA (4398 + 29 + 27805 = 32232) Subtract the result from RA-pgsused (32188 - 32232 = a negative number) Since the result is a negative number you need to increase the RA configuration. You want the result of the calculation to be between 0.5% and 2% of RA-pgsused. If the result of the calculation is above 2% you need reduce the RA configuration. Cheers, Tony. #include <standard disclaimers> ---------- From: Manoj To: 'informix-list@rmy.emory.edu' Subject: lchwaits, read aheads Date: Friday, 12 September 1997 23:27 All, Are there any guidelines for the below ? ixda-RA idx-RA da-RA RA-pgsused lchwaits 4398 29 27805 32188 55 Thanks, Manoj Schroff, Two Way TV Ltd, UK +44(0)181 996 8221 manoj@mailhost.twowaytv.co.uk http://www.twowaytv.co.uk