- Yes, I built my million-record table in the USERS tablespace so the
DBF is the same one in the OP.
- We're using a Hitachi SAN 9980 (my SA says it's also referred to as
HP's XP 1024).
- The LUN is 8 disks RAID 5.
On Mon, 2006-12-11 at 11:15 -0800, Kevin Closson wrote:
> 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 ?)
>
>
>
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Dec 11 2006 - 13:49:06 CST
