RE: oracle block size = file system buffer size

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Thu, 30 Sep 2004 16:50:16 -0400
Message-ID: <AA29A27627F842409E1D18FB19CDCF275A9A70@AABO-EXCHANGE02.bos.il.pqe>

Joe,

It's definitely a good idea for blocksize =3D filesystem block size.

Multiple blocksizes are there for transportable table support.

Steve Adams has lots of stuff on it here: http://www.ixora.com.au/tips/buffered_block_size.htm

Note that this is useful for databases NOT using directI/O.

Check out the link to Steve's article. He does his usual excellent job explaining the concepts.

-Mark

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Joe Armstrong-Champ Sent: Thursday, September 30, 2004 4:32 PM To: oracle-l
Subject: oracle block size =3D file system buffer size

I have read that the oracle block size should be the same size as the=20 file system buffer size (when not doing direct io). If this is true then =

what is the point in being able to have multiple block sizes? Is this=20 feature only helpful for databases using direct io?

Joe

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Thu Sep 30 2004 - 15:45:52 CDT