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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: HP UX-11 I/O vs Sun Solaris 2.6 I/O

Re: HP UX-11 I/O vs Sun Solaris 2.6 I/O

From: Tony Vecchiet <Tony.Vecchiet_at_xilinx.com>
Date: Wed, 12 Jul 2000 17:15:32 -0700
Message-Id: <10556.111909@fatcity.com>


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;

 filename="tony.vecchiet.vcf"

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

Original text of this message

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