Re: DB Block Size

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 18 May 1999 20:43:34 +0100
Message-ID: <927057541.8124.1.nnrp-01.9e984b29@news.demon.co.uk>

I once built a 4Tb database on a 2K block size because that was the best size for the data and its acquisition pattern.

The biggest issue about block size to most people is the possible conflict between Oracle blocksize, file-system blocksize, and LVM block size and device block size.

The best solution is to check whether your kit works best at any particular block size(s) before going through the hassle of change.

(there is a little C code on my website that may be useful).

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

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 - 14:43:34 CDT