| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle manual : Greater O/S block size......
Yes, it is true that a larger Oracle blocksize is better but... up to a =
point that involves the OS ability to read disk blocks from the disk =
sequentually and fill the Oracle block with one pass/revolution of the =
disk. If the OS read is slow than you are wasting cpu time waiting for the =
next revolution to fill the datablock. I have not performed any benchmarks =
and I don't know where to find them for all the possible combinations of =
systems,disks,controllers, etc. But the theory sunds solid.
Ron Rogers
DBA
ATL.GA
>>> ipal_at_hotmail.com 07/11/00 03:46PM >>>
Hi list,
Here is from Oracle Manual :
"The operating system I/O size should be equal to or greater than the=20
database block size".
And the benchmark said that greater O/S block size is better than small =
O/S=20
block size.
My db_block_size now is 8K, and O/S block size is 512 bytes.
Should I increase the O/S block size for better performance ? Have you =
had=20
the benchmark in your machine ?
Oracle 805, Sun OS 2.6, SGA 2 Gb, vxfs and ufs, OLTP and Batch application.=
Thanks for any suggestion.
Aldi
Oracle DBA
--=20
Author: Aldi Barco
INET: ipal_at_hotmail.com=20
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Jul 11 2000 - 14:37:21 CDT
 |
 |