Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: HP UX-11 I/O vs Sun Solaris 2.6 I/O
This is a multi-part message in MIME format.
--------------356B3E0F92B74D7D136B415E Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit
Steve,
our sys admin is using the dd command and some custom C programs to read
data from various file systems. He repeats all tests on both systems. For 8k blocks,
HP is almost 2x slower.
On the database side, we're using sql trace and tkprof. Exact same
databases, the tkprof output is exactly the same, except the IO time is
lots longer.
tony
Steve Adams wrote:
> Hi Tony,
>
> What statistics are you using to quantify the difference?
>
> Regards,
> Steve Adams
> http://www.ixora.com.au/
> http://www.oreilly.com/catalog/orinternals/
> http://www.christianity.net.au/
>
> -----Original Message-----
> From: Tony Vecchiet [SMTP:Tony.Vecchiet_at_xilinx.com]
> Sent: Thursday, July 13, 2000 8:47 AM
> To: Multiple recipients of list ORACLE-L
> Subject: HP UX-11 I/O vs Sun Solaris 2.6 I/O
>
> We are migrating to HP UX-11 from Sun Solaris 2.6 and are
> finding I/O to be real slow at the OS level on HP. We're using Oracle 8.0.5.2
> and 8k block sizes (dbblockbuffers). The Sun system uses 7200rpm disks
> and ultra scsi, the HP uses their FC60, fiber channel and 10k rpm disks.
> On both Sun and HP we are using file systems, not raw partitions.
> I'd think that the HP IO system would be faster, but it's much slower (35-50% slower).
>
> Does anyone have any ideas on what to check or do?
> thanks
>
> << File: tony.vecchiet.vcf >>
> --
> Author: Steve Adams
> INET: steve.adams_at_ixora.com.au
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--------------356B3E0F92B74D7D136B415E
Content-Type: text/x-vcard; charset=us-ascii;
name="tony.vecchiet.vcf"
Content-Transfer-Encoding: 7bit Content-Description: Card for Tony Vecchiet Content-Disposition: attachment;
begin:vcard
n:Vecchiet;Tony
tel;fax:408.377.3153
tel;work:408.879.4771
x-mozilla-html:FALSE
org:Xilinx, Inc
adr:;;2100 Logic Drive;San Jose;CA;95124;USA
version:2.1
email;internet:tony.vecchiet_at_xilinx.com
title:Manager, Oracle Database Group
x-mozilla-cpt:;14432
Received on Wed Jul 12 2000 - 19:15:32 CDT