Discussion Locked

Oracle database on intel: Linux vs Windows

0 helpful
20 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

We are planning upgrade our main database cluster (rs6000/aix) to Oracle on Intel, research done give a lot of papers from dell, hp, intel that about roi of moving out of risc/unix but there is no clear evidence about performance issues between LINUX and Windows Server as the selected OS.

Do you have info about an Oracle LINUX vs Windows ROI and TCO ? What about performance ? I would appreciate facts beyond "Larry" betting on Linux and something specific about Oracle since I'm not comparing the OS, but the performance Oracle has in both platforms.

I do have a personal technical opinion in favor of Linux as Oracle platform, so would love to really read goog arguments comparing Windows vs LINUX as a good platform to run Oracle database.

Thanks in advance,

20 replies

by apotheon

I'm afraid I don't have a whole lot of information to offer here, not having worked with Oracle a whole lot. What little I've got, though, I offer.

I haven't seen any benchmarks, nor had the opportunity to perform any useful comparisons, but simply based on the characteristics of the OSes themselves I'd imagine that Linux would be the better performer by far with Oracle. This, of course, is based on a number of largely self-evident factors, such as the lack of a need to support wholly unnecessary GUI environments in Linux, thus freeing up resources for the database itself.

On the other hand, the Linux port of Oracle is relatively new. I don't know how well the port was accomplished. Assuming the guys at Oracle did a halfway decent job, though, Oracle on the Linux platform should leave Oracle on the Windows platform in the dust. You'll have to look into the Oracle port's characteristics, though, to be sure. The most likely place for that sort of information would probably be someone technically knowledgeable at Oracle. This means you'll have to talk to someone other than their sales staff.

Point of interest: Apparently, Oracle controls data management at the filesystem block level. This would explain the high-end scalability of Oracle that is so vaunted in the industry, of course, because by managing data at that level directly, a lot of wasted time in disk churning on the server is cut out. Seek times wouldn't be shortened any, of course, but the translation of a request for data (for instance) from DBMS activity to drive access would be streamlined drastically.

The downside comes up with filesystems that don't use blocks. Sector-based filesystem management, for instance, would be problematic for Oracle. A real-world example of the incompatibilities involved would be ReiserFS. This filesystem doesn't manage data at the block-level. Because it doesn't limit itself to data management in segments no smaller than blocks, ReiserFS makes far more efficient use of storage capacity when dealing with small files, but this also makes it incompatible with Oracle, it seems. Thus, when setting up Linux database servers for use with Oracle, make sure you choose the right filesystem. Ext3 should work fine, and (like ReiserFS) is a journaling filesystem.

by cagandhi

by vijayvaradan

While I can't comment on the performance (actual, not claimed) of Oracle on Linux, I can definitely tell you that Oracle on Windows is a NO-NO.

I worked for a major online drugstore and we used Oracle on NT. It was a bad idea. We should have gone with Oracle on Unix or SQL Server on NT. The combination of Oracle and NT is very, very bad. We had gold support from both companies and all we got was a whole lot of finger pointing from both Oracle and Microsoft - not laying the blame on one or the other here, just that both don't work well together and both don't __WANT__ to either. The standard suggestion we got from Oracle was to move to UNIX and things would be golden. Similarly from Microsoft was the suggestion that we ditch Oracle and move to SQL Server on NT.

Though I was a developer, I took upon myself the task of stress testing Oracle on NT (with and without Multi-threaded Server [Oracle MTS]) and Oracle MTS (yeah the database engine) on NT would hang regularly after a few hours of pounding. Oracle support's solution was to move the DB to Unix.

by jim.bassett9

Yes I remember problems with Oracle on NT as well as on DEC's Vax systems and from what I have heard and expereinced there is always problems including with Oralce on Unix. Anyway we upgraded to Win 2000 and later Windows 2003 and never experienced any problems using Oracle. I suspect many on this coment section will be couching out the usual Microsoft is the prince of darkness trash rather than just honest analysis. Linux/Unix is a good OS but so is Microsoft's OSs and each have their pros and cons just as all things do.

by irish_iiii

Considering Oracle recommends Linux for those customers who haven't decided on a platform, I would strongly suggest following their recommendation. It is going to be difficult choosing platform based purely on ROI and TCO, since every study tends to differ depending on what, if any, alterior motives exist. But Linux has become the primary platform with Oracle. Patches are typically released on the platform earlier. Product updates are typically done there first. And Oracle has a good knowledge base when it comes to performance issues running the database on Linux.

by jrmint

From what I understand Oracle develops their database under Solaris and then ports it to Windows. That's why the Solaris version is always up first and then a lag until the Windows release. THey are making a huge push to go Linux. We run everything under Solaris because management is a little nervous of Linux otherwise we would be.

by carlosaq

"Over the years, Oracle has worked very closely with Sun to ensure that Oracle products are fully optimized and certified to run on the Solaris platform."
Prem Kumar, Vice President, Server Technologies, Oracle Corporation
There is a nice begin to prove these option http://www.sun.com/software/solaris/binaries/

by romerogt

The main issue that affects linux is support, I see another propietary Linux to have more problems in this field. How mature is Oracle on Solaris/Intel, I have a met a lot of people that uses Oracle/Solaris but on sparc, and I can say nothing bad about their installation, but is there evidence on Intel ?

My main issue is getting out of propietary hardware (at least) platforms, the OS is another story, because despite being Linux it will be a commercial one, so I also get kind of tied.

by carlosaq

"Over the years, Oracle has worked very closely with Sun to ensure that Oracle? products are fully optimized and certified to run on the Solaris platform."
Prem Kumar, Vice President, Server Technologies, Oracle Corporation
There is a nice begin to prove these option http://www.sun.com/software/solaris/binaries/

by niallbulk

I've been to several Oracle presentations over the last year where they informed us that Oracle now develops on Linux (and not Solaris). They seem to favour RedHat.

In the past they used to develop on Solaris but they appear to have changed tack.

by bizrisky

We ran an "unscientific" performance comparison of Oracle 9i on win2000 and Red Hat Linux 7.3 on identical hardware (Dell 2650 server) and Linux performed about 5% faster.

Apparently a big thing to watch out for is that SCSI RAID drivers under Linux may not be the best performers. Others may be better able to comment on this.

Oracle on Windows is implemented in 1 address space for each instance (process) and muliple child threads. You can run into a memory limit as the largest process size is about 1.7gb. If you go to win2000 advanced server you can get an extra 1gb with the /3gb boot.ini switch. If you have gobs of memory you can implement Oracle VLM with the Win2000 PXE extension (shades of EMM386, ugh). I understand the Oracle on Linux is implemented like UNIX, multiple processes, each with a fairly large size limit.

We run 15 Oracle instances (8.1.7 or 9i) on various Win2000 boxes and are very happy with performance and stability. We also run 12 instances on HP/ux where we want greater scalability.

by romerogt

This is a question, not a suggestion.

Have you considered migrating w2k boxes to HP/ux or Linux ? What would you say ?

And, have you got the greater scalability (and stability) from HP/UX ?

by snoopdoug

Although you can get Service for Unix from Microsoft, that still doesn't give you all of the admin tools you are used to.

Also Linux does not enjoy the constant security patch activity as Windows. Unless you view that as job security, :-).

doug

by damoncarr

RomeroGT,

Windows 2003 is the most advanced OS on Intel hardware that I have ever seen due to the many optimizations it can make to run on that platform (which does not mean by default it is the best for Oracle but IS a compelling fact and SHOULD dramatically influence it). Are you using TCP/IP? Look at the architecture of the Windows 2003 TCP/IP stack. It has been moved to a much lower 'ring' of the OS which dramatically improves performance for TCP/IP apps like Oracle and Web Servers. I would need to learn more about the characteristics of your database however. What development tools are you using? .NET? J2EE? Other?

What is your budget? Is this TPS foccused? Data Warehourse Focused? A combination? There MIGHT be considerations where LINUX could be argued if you are budget strapped but I don't know of benchmarks that would show that it would perform better. I am making a very educated quess that ir would perform WORSE. In fact ROI and TCO in what I have seen IN GENERAL favor Windows 2003 but I have not seen this for Oracle I admit. I would need to learn a lot more about your environment. If you want to send me details I will try to give a more complete answer.

Going to Intel is a good idea most likely but if I had to throw out a 'catch all' I would say Windows 2003 should be the ticket without knowing more about your budget, operational characteristics, etc. Frankly I do not see how you could go wrong if Oracle is fully supporting Windows 2003. I would not use any previous OS version from Microsoft as that would just be a waste.

Kind Regards,
Damon Carr, CEO and Chief Technologist
agilefactor

by bastien1

the sheer weight of patches to the windows OS and the need therefore to stop and restart the machine make it unsuitable for a 24/7 environs.

by romerogt

Some have cited the patching issues on Windows, but I would like to know what the ones actually using Oracle on Linux have to say about patching...

There is no OS or software piece that is so perfect as to not need pathing, how do you manage and how frequent is it to patch a Linux for Oracle (in the real world).

by choppit

It's my understanding that Oracle performs better on *nix although I personally can't cite any reasons. Because Oracle is *the* definitive RDBMS, Microsoft 'wishes' it ran better on Windows. I'd take Oracles recommendation, whatever that might be.

by nan2011

No cheguei a tirar uma concluso real, vi alguns testes que foram feitos e vou postar um link. O linux Red Hat apresenta uma performance muito boa com relao ao windows server quando se trata de oracle, por diversas questes, como ambiente. No linux, voc possui uma ferramenta de linha de comando mais poderosa do que o prompt do windows, e quando necessrio, pode utiliz-la no caso de algum caso grave. No caso do windows, apenas num caso muito grave voc conseguir ter acesso a alguns dos componentes no modo texto em segurana para fazer intervenes, digo por algumas opinies e fatos que vi, no por experincia, ento tire sua concluso, vou postar um link aqui com um comparativo de performance entre linux e windows.
http://www.dba-oracle.com/art_builder_linux_oracle.htm
i'm sorry, i don't realized my post in portuguese, after I'll post in english, rigth?

This discussion is closed to new replies.