Re: Database Block Size

From: Viacheslav Leichinsky <v_leichinsky_at_ittoolbox.com>
Date: Tue, 24 Oct 2000 08:18:51 GMT
Message-ID: <8t3gl9$ktb$1@nnrp1.deja.com>

In article <39ec3949_at_news.iprimus.com.au>, "Howard J. Rogers" <howardjr_at_www.com> wrote:
> Comments below
> And that rather means the above comment is *not* the case. Cooked
Unixes
> require 8K (subject to updates to the O/S). Raw Unixes -all bets are

Hi!

Could you clarify me this situation ? I have Reliant UNIX box with 16k memory page and Oracle on vxfs with 8k block size. What is the best db_block_size - 8k or 16k ? Should I match db_block_size to file system block size or memory page? And what about raw case? I'm wondering about relationship between db_block_size and memory page.

Regards,
Slava.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Oct 24 2000 - 03:18:51 CDT