Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Number of IOs Per Second
bdbafh_at_gmail.com (Paul Drake) wrote in message
> I've seen a system with a dedicated EMC Clarion CX200 unit (resold by
> Dell).
> dual pathed.
> can crank out 1800 operations per second.
> with a db_block_size = 8192, that isn't that impressive
> as its just over 14 MB/sec, for single block access
> (db_file_sequential_read).
>
> when those IOs are 1 MB, 1800 IOs per second is huge.
> way larger than a dual pathed 2 Gbps controller can support.
> (in other words, theorhetically impossible).
okay, didn't get the throughput stats, but was performing a re-org
this evening.
saw 3000 IOPs in the CX200 via the PowerPath software installed on a
Dell PE6650, attached via a dual path 2 Gbps (full duplex) FCHBA.
I had set the db_file_multiblock_read_count to 128, sort_area_size =
128M, as I was only using a single session for rebuilds. No way was I
getting 1 MB reads at 3000/sec, but I could certainly see what Juan
Loiza was talking about with SAME.
The RAID volume of interest was an 8 disk RAID 10 volume.
I'll try to get some real throughput stats tomorrow.
-bdbafh Received on Thu Aug 12 2004 - 00:27:40 CDT