Re: general recommendations for setting block size?

From: Wiz-of-Oz <nsouto_at_my-deja.com>
Date: Sun, 12 Sep 1999 14:42:35 GMT
Message-ID: <7rge4q$ucs$1@nnrp1.deja.com>

In article <936971378.27376.0.nnrp-13.9e984b29_at_news.demon.co.uk>, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:

> Have to say though, that unless the file system
> allows for 2K writes (e.g. with Veritas direct I/O
> option) then you generally have to choose
> between an optimum Oracle blocksize and
> an optimum O/S blocksize or move to raw
> devices.

Very good point, Jonathan. Add to that things like EMC disk arrays and such other "animals" and the whole line for 2K,4K,8K or whateverK blocks starts to get very fuzzy...

--
Cheers
Nuno Souto
nsouto_at_my-dejanews.com
http://users.bigpond.net.au/the_Den

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sun Sep 12 1999 - 09:42:35 CDT