General discussion


Oracle database on intel: Linux vs Windows

By romeroGT ·
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,

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

advice from a non-expert

by apotheon In reply to Oracle database on intel: ...

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.

Collapse -

Just go through the URL bellow:

by cagandhi In reply to Oracle database on intel: ...

Read my Next POST

Collapse -

Good URLs but what happen to this one...

by romeroGT In reply to Just go through the URL b ...

Some interesting articles, the analisis on reports on windows being cheaper than linux is great.

There are some of them refer to this URL:

It has a lot of links to it, but page, author and article seems to be erased from Internet, I wonder why ?

Collapse -

Go with Oracle on Linux

by vijayvaradan In reply to Oracle database on intel: ...

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.

Collapse -

Why NT there is Win 2000 and Win 2003

by jim.bassett In reply to Go with Oracle on Linux

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.

Collapse -

Oracle recommends Linux

by Irish_iiii In reply to Oracle database on intel: ...

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.

Collapse -

Oracle develops code on Solaris

by jrmint In reply to Oracle database on intel: ...

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.

Collapse -

Be consider Solaris

by CarlosAQ In reply to Oracle develops code on S ...

"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

Collapse -

Good, what about support and costs...

by romeroGT In reply to Be consider Solaris

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.

Related Discussions

Related Forums