Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » suse oracle »

Re: [suse-oracle] Help 10g Vs MSSql

Fabrizio Magni

2006-05-29

Replies:

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
>
>
©2008 dba.5341.com - Jax Systems, LLC, U.S.A.