RE: Hitachi 9000 (was RE: 2GB or not 2GB )

I check my data and found it is actually 102 GB in 66 minutes for a rate of 26 MB/sec for a full table scan. "Sequential reads" are much slower, around 8-10 MB/sec.

Here is what I know about the architecture:   Two Hitachi SANs
  2 SANs are shared by 4 Sun 15K servers   Disks are 146 GB each
  Each disk split into 35 GB Logical Volumes   8 disks in a logical disk group (Raid 5 w/ 128K stripe)   2 HBA per SAN. I think 1Gb, but not sure   Veritas file system
  56 GB read/write cache

I know Raid10 would be better, but Raid5 is the corporate direction. The other problems seem to be that the disks are shared by multiple databases and possibly the stripe size.

Any comments would be appreciated.

Keith

>
> That is 113MB/s. You wouldn't happen to have 1Gb HBAs would you?
> Is this data striped across, say, 10 spindles?
>

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