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

Home -> Community -> Mailing Lists -> Oracle-L -> Antwort: OT: HPUX SCSI Performance

Antwort: OT: HPUX SCSI Performance

From: <Alex.Apostolopoulos_at_secartis.com>
Date: Wed, 05 Feb 2003 10:04:14 -0800
Message-ID: <F001.00544867.20030205100414@fatcity.com>

Hi david,
of course there is something you can do !!!! First tell your sysadmin to stop being so negative !!!

Transfererate is data/time, where time is the sum of three steps
- seek: time to position the heat to the right location

First you have to do tests to find out where you loose the biggest percetage of time.
If transfer is your biggest problem the solution is easy : place the files on the out side
sectors of the discs ( outer sectors are up to 4 times faster that inner sectors ).
pls refer to man pages of mkfs/lvm to see how you can set up partitions or luns
on hp-ux.
If seek is your problem than a reorganizing of the data into a more sequential way
or setting up bufferpages (kernel parameter in hp-ux) might give you an advantage
if the inodes are used frequently and therfore are stored in the bufferpages so no
physical read takes place. But of course setting up bufferpages takes away memory
so there is a trade off when working with oracle. more or less the same is true for latency.

hmmm just said "same" ... google for same and you will find some interesting white papers
(S.A.M.E = stripe and mirror everything)

HTH alex

                                                                                                                                 
                      david hill                                                                                                 
                      <david.hill_at_lech         An:      Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>              
                      ateau.ca>                Kopie:                                                                            
                      Gesendet von:            Thema:   OT: HPUX SCSI Performance                                                
                      root_at_fatcity.com                                                                                           
                                                                                                                                 
                                                                                                                                 
                      05.02.2003 17:38                                                                                           
                      Bitte antworten                                                                                            
                      an ORACLE-L                                                                                                
                                                                                                                                 
                                                                                                                                 



Hi Guys
I'm hoping there is sysadmin in the list that can help me.

We just received a brand new Itanium Server to play with It has 2 U320 disk not striped or mirrored or anything

Doing test and monitoring them through glance, is giving me a transfer rate of about 15Megs a sec
These should be up around 60 - 80 megs right?

My sysadmin says there is nothing he can do. Can someone tell if there is some sort setting he hasn't set or a config somewhere?

Thanks.
David Hill

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: Alex.Apostolopoulos_at_secartis.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
Received on Wed Feb 05 2003 - 12:04:14 CST

Original text of this message

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