RE: I/O and db_file_multiblock_read_count

1. Yes, I built my million-record table in the USERS tablespace so the
DBF is the same one in the OP.

2.  We're using a Hitachi SAN 9980 (my SA says it's also referred to as
HP's XP 1024).

3.  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

Other related posts: