Re: Database Block Size

nsouto_at_nsw.bigpond.net.au.nospam (Nuno Souto) writes:

> On Tue, 17 Oct 2000 15:49:35 +0200, "Frank" <frankbo_at_interaccess.nl>
> wrote:
>
> >Will go for 8k on Unix as from now on. Cooked, that is.
>
> Take it easy when using EMC boxes and/or Veritas. That may change the
> ground rules. You may have to do some digging in the doco to find out
> the real block size for cooked.

Oddly enough Veritas recommends 2k block size.

Conceivably the smaller the block size the more effective the Oracle buffer cache and veritas cache can be. But it still feels weird.

And they recommend a single large strip set (but not more than 10-14 disks :) But i suspect they say that just because that's easier than explaining anything more complicated and it's guaranteed to not be too bad.

-- 
greg