Does Oracle work better on Windows or Unix/Linux?

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Oracle database design and architecture Can I download DBCA for Oracle Express Edition? How to recreate an Oracle index in a new schema with the CREATE command Using Oracle Universal Installer to install Oracle with Pro*C Defining Oracle database repository vs. information repository Can I create multiple schemas in Oracle for one user? ORA-12514 error when connecting to the Oracle database through Toad Solving the ORA-00904 error: invalid identifier in Oracle How to tune SQL UPDATE statements for an Oracle 10g upgrade Will queries run slower in a smaller Oracle buffer cache? Using a database link to connect two Oracle apps instances Oracle on Linux Will Sun help Oracle eclipse IBM? Oracle database in the cloud floated at Harvard lab E-discovery firm swaps out Microsoft SQL for Oracle RAC Oracle releases VM virtualization templates, boasts Linux momentum What happened to Oracle's Red Hat challenge? Oracle Database 11g makes waves at Burlington Coat Factory Firm dumps MySQL on Red Hat for Oracle Database on Oracle Linux Oracle and the rise of the virtual machine Oracle 11g for Linux hits the street Grid computing adoption slow amid fears of complexity

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

That's a loaded question that isn't very easy to answer! Part of it depends on what you mean by "better." So I'll give you some highlevel opinions that can help you out. Keep in mind that for each of these broad opinions, there are probably quite a few exceptions.

I prefer running Oracle on Unix. Oracle is first created on a Unix platform. Unix servers also have a reputation for performing well and for high availability. The price tag for a good, high-end Unix server is not cheap though. And in addition to the DBA, you also need a good sysadmin to support your Unix server.

Oracle on Windows used to perform much more poorly, but Oracle has gotten their product to work well on Windows in more recent versions. And since Windows 2000, the Windows OS has become much more stable than it used to be. You can also get a good Windows server for a very reasonable price. Windows is also easier to administer than a Unix server, for the most part.

Oracle Corp has spent a lot of money and effort on Oracle on Linux. Oracle on Linux has become fashionable lately. You can get a relatively inexpensive Intel platform to run your Linux OS and throw Oracle on there. The only point I'd mention is to make sure that you use SCSI drives instead of IDE drives. IDE drives won't scale nearly as well as SCSI drives should your database require the high I/O throughput. Many companies are moving to Oracle on Linux to keep costs down (like Windows), but yet get good performance and good stability (like Unix).

Keep in mind that the above are just some guidelines. There are exceptions to every one of those rules.