Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Number of IOs Per Second

Re: Number of IOs Per Second

From: Paul Drake <bdbafh_at_gmail.com>
Date: 11 Aug 2004 22:27:40 -0700
Message-ID: <910046b4.0408112127.7629ac81@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US