Q

Windows vs. Linux continued

I read your answer to the question, "What is the difference between running Oracle on Windows and running it on Linux?" What I really wanted to see were benchmarks for performance, reliability and intrusion. That would help us decide what platform to move to next. Benchmarks are very difficult to come by and to trust. One can look at the TPC benchmarks, but you'll have to take these figures with a grain of salt. What is a benchmark...

today will be old news tomorrow. If you pay attention to these benchmarks, you will find Oracle on top one day, SQL on top the next, and so on. And any benchmarks typically are far removed from "real world" situations. The minute you throw Oracle on a Windows server and are happy with its performance, I can come up with a Linux server, with more memory, faster CPUs, and faster disk that will outperform your original configuration. And vice-versa. Personally, if you are really worried about performance, then you might want to look at running Oracle on a high-end Unix platform.

But if you want generic guidelines, then my rules of thumb are as follows. First, Oracle on Linux is typically faster than Oracle on Windows, provided that your Linux server is not running its GUI interface. The GUI interfaces for the OS can slow things down quite a bit. Second, in either case, make sure that you are using SCSI disks (or even Serial ATA disks). Just stay away from IDE disks if at all possible. IDE disks can't satisfy concurrent disk requests. It has to single stream disk requests and this can slow things down.

And it has been my experience that Linux is more stable and more secure than Windows. Windows 2000 Server and Advanced Server have become much more stable so the differences might not be that much. I'd rather deploy Oracle on Linux, but I've often deployed Oracle on Windows as well with great success.

This was first published in October 2003

Dig deeper on Oracle database design and architecture

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close