First, thank you all, this list rocks!!.
I've read all your advices, and agreed with you, about the fidelity and
confidence of the tests we're running, they are not the best approach,
neither we have the best hardware settings to make it. But lamentably this is
all we got now, and even worse little time to test, so please, help me to win
this fight boosting oracle's performance.
I've just realized that 10gR2 for itanium, already patched, doesn't have async
i/o linked by default, i had to do this:
wget -c
http://oss.oracle.com/projects/libaio-oracle/dist/files/libaio-oracle-0.3.0.tar.gz
$ tar -zxvf libaio-oracle-0.3.0.tar.gz
$ cd libaio-oracle-0.3.0
$ ./configure
$ make
$ cp libaio-oracle.o $ORACLE_HOME/rdbms/lib/skgio.o
$ cd $ORACLE_HOME/rdbms/lib
$ make PL_ORALIBS=-laio -f ins_rdbms.mk async_on
Now oracle shows linked to libaio whe ldd/nm on it, here i've a doubt, should
i've to execute:
$make PL_ORALIBS=-laio -f ins_rdbms.mk ioracle
Or this is only necessary for 10gR1/9i ?
Rebooted the server and added "elevator=deadline" in order to use i/o
scheduler.
So far my SLES9/10gR2 combination has these settings on:
1) Oracle I/O async : disk_asynch_io=true, filesystemio_options=asynch
2) Linux I/O scheduler, deadline (according to fabrizio.magni's webpage)
3) Oracle data partition mounted with ext3 and writeback option.
Did i miss some step?, should i need something extra?
Thank you all for answering, i'm learning a lot with every advice.
Best regards
Oxiel
El Lun 29 May 2006 02:36, Fabrizio Magni escribió:
> Hello Oxiel,
> first of all I'm going against my interests: sql server has really great
> performance on low profile hardware such as intel.
> But a choice of the right platform shouldn't be based on performance.
>
> To be back on your question: how to boost performance of oracle on linux?
> There are a couple of Scalzo's papers on the topic. They are old but you
> can still find useful tips.
> Then you can try changing the default I/O scheduler. Benefits of this
> approach depends on your workload so test carefully!!!!
>
> Still I suggest you to prepare a broader number of justifications if you
> want to chose a solution above aqnother.
> Things like: stability, backup and recovery scenarios, internal
> administration skill of your organization, development advantages of the
> two solutions and so on.
>
> Regards
> Fabrizio
>
> On 5/29/06, Oxiel Enrique Contreras Vargas <oxielc@(protected):
> > Hello friends.
> >
> > That's it, a friend's boss has received the "great proposal" from MS to
> > switch
> > from Oracle 8i/Tru64 to MSSQL/W2K, at "really low prices and without
> > precedent performance", so now testings are been done, in order to
> > migrate to
> > 10g/Linux or MSSQL/W2K over itanium, which ever perfoms better.
> >
> > We're trying to convice people to stay at the 10g/linux side.
> >
> > I've searched tips to tune 10g over sles9 for itanium, but couldn't find
> > something clear, so this is the best place to ask for help.
> >
> > This is the server where all the tests are being done:
> >
> > HP rx4640 with Itanium2 processors
> > 4Gb of RAM
> > One internal SCSI Disk (80GB)
> >
> > Oracle 10gR2 with patch applied.
> > Kernel updated for SLES9 - 2.6.-7.257-default
> >
> > Swap 8 GB
> >
> > Root partition, opt partition and oradata partition were created on the
> > only
> > disk with ext3.
> >
> > The data partition for oracle has ext3 with writeback option mounted as
> > previos messages from this list were advicing.
> >
> > Default kernel settings from /etc/sysconfig/oracle are been used,
> > and /etc/security/limits.conf values for oracle user according to
> > Oracle's installation guide.
> >
> > What else can i do in order to squeeze speed to oracle/sles9 ??
> >
> > Thanks in advance.
> >
> > Oxiel
> > Chiacchiera con i tuoi amici in tempo reale!
> > http://it.yahoo.com/mail_it/foot/*http://it.messenger.yahoo.com
> >
> > --
> > To unsubscribe, email: suse-oracle-unsubscribe@(protected)
> > For additional commands, email: suse-oracle-help@(protected)
> > Please see http://www.suse.com/oracle/ before posting
Chiacchiera con i tuoi amici in tempo reale!
http://it.yahoo.com/mail_it/foot/*http://it.messenger.yahoo.com
--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting
