RE: I/O and db_file_multiblock_read_count

Your tests prove that the I/O subsystem drops from 115MB/s to 40MBs if doing a sequential scan of a really small file. It generally is not the case that larger application requests result in longer scan times, but it raises some questions:

1. Is users01.dbf the same file invovled in the test reported in the OP?
2. What kind of SAN is under users01.dbf?
3. What kind of LUN is under users01.dbf (e.g., 2 disks RAID 1+0 striped with 32KB ?)

>>>-----Original Message-----
>>>From: oracle-l-bounce_at_freelists.org
>>>[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kevin Lidh
>>>Sent: Monday, December 11, 2006 6:39 AM
>>>To: Kevin Closson
>>>Cc: oracle-l
>>>Subject: RE: I/O and db_file_multiblock_read_count
>>>
>>>I apologize for the tardiness of my response. This is the
>>>result of timing the dd. It seems to indicate the same
>>>thing as the scattered read test. Or am I reading that wrong?
>>>
>>>(8k * 16)
>>>Unix> time dd if=/ora/data/bordcdw/users/users01.dbf of=/dev/null
>>>bs=131072
>>>1290+1 records in
>>>1290+1 records out
>>>
>>>real 1.4
>>>user 0.0
>>>sys 0.5
>>>
>>>(8k * 128)
>>>Unix> time dd if=/ora/data/bordcdw/users/users01.dbf of=/dev/null
>>>bs=1048576
>>>161+1 records in
>>>161+1 records out
>>>
>>

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