RE: I/O and db_file_multiblock_read

From: Mladen Gogala <mgogala_at_vmsinfo.com>
Date: Mon, 11 Dec 2006 16:06:11 -0500
Message-ID: <00ca01c71d68$30009fa0$232b650a@nycwkswxp2829>

That's not particularly interesting. Linux has maximum atomic I/O read smaller then 1MB (I believe it's 256KB?) so using 1MB blocks will

Inevitably break one I/O request into many.

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still
Sent: Monday, December 11, 2006 3:46 PM
To: kmoore_at_zephyrus.com
Cc: oracle-l
Subject: Re: I/O and db_file_multiblock_read_count

Interesting that the 64K blocksize significantly outperforms the 1M blocksize.

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

Received on Mon Dec 11 2006 - 15:06:11 CST

RE: I/O and db_file_multiblock_read_count