Re: DB Block Size

From: Brian Gallagher <briang_at_iona.com>
Date: Tue, 18 May 1999 13:53:21 +0100
Message-ID: <7hro2h$4pr$1@bvweb.dublin.iona.ie>

Hi Julia,

I'm just back from a performance tuning course and they really recommend 8k as a minimum size nowadays i.e. for
performance point of view

regards
brian

Julia Cristina Varela de Montoya wrote in message <7hrfue$m53$1_at_bgtnsc02.worldnet.att.net>...
>We run PeopleSoft (payroll, benefits admin) on an AIX machine on v. 7.3.4.
>The DB size is about 8g and growing. Our block size is 4k. Row chaining
is
>not currently a major problem. Does anyone have an opinion as to whether
>that block size is a little small for this application. We are considering
>doubling it.
>
>Thanks for any replies.
>
>
Received on Tue May 18 1999 - 07:53:21 CDT