Re: Oracle on Linux vs NT

Thanks for the intelligent response Doug. I realize there are many other factors involved in the selection of a OS, but the main one I meant to address was performance of the OS.

Specifically, does one OS have a performance advantage in networking or disk io? Does one implement SMP better than another?

I really love using *NIX or it's derivatives. We were only on NT because of the price break that Oracle gives you. Now that Linux is in the same pricing category as NT, I want some evidence to switch to Linux or stay with NT.

Just to answer Doug's questions:

The database will be about 60GB in size with only one instance running on the server. The longer it can stay up without any intervention, the better it will be. It should have an average of 5 or 6 regular users, with sporadic access from a web server. It is used primarily for monthly reporting and is run in NOARCHIVELOG mode. We take cold backups whenever we load new data (usually monthly). The server will only be a database server (not multipurpose).

-Dave

volleyball_at_ntr.net wrote:

> On Wed, 01 Sep 1999 15:44:12 -0500, Dave Zuzga <dzuzga_at_isdinc.com>
> wrote:
>
> >Does anyone have any recommendations on which OS to use for an Oracle DB
> >running on an Intel 4 Processor Xeon machine? It has 1GB RAM, a DPT
> >RAID Controller, and 95 GB of disks.
> >
> >I'd like to hear the pros/cons of using Linux vs NT for an Oracle
> >server.
> >
> >Respond here or via email to dzuzga_at_isdinc.com
> >
> >Thanks,
> >
> >Dave Zuzga
> >
>
> There is really no way to answer this question without more info. Each
> OS has strengths and weaknesses and each has it's own unique support
> requirements. Some of the questions you should ask yourself may allow
> you to answer this question. For example
>
> - How big is the actual DB?
> - Are there multiple servers or multiple instances (ie test, qa and
> prod)
> - Is 7x24 a requirement or can you afford a weekly NT reboot?
> - How many users? (Memory, threads/processes different between nt and
> unix, NT more efficient for limited users, Unix more scaleable)
> - What expertise do you currently have in house?
> - What kind of expertise do you have availble outside
> - What tools will you be using for backups, admin etc...
> - How complex is your batch process (do you need KORN - Available for
> NT but a bit more stable under Unix)
> - Will your box be a DB server only or multipurpose.
> - What about scheduling software? Unix has beeter build in scheduler.
> - Is security an issue? how would you integrate this into your other
> technology?
> - What client software will you be using?
>
> These are a few to get you started. Every tool has it's place. So many
> people think a hammer is always better than a screwdriver in all
> situations. I like to know what the job is and then select the correct
> tool.
>
> Hope this helps...
>
> Doug Coan
> Senior Client Server Systems Integrator
> DCoan_at_aegonusa.com
> "Live to Learn and Learn to Live"
Received on Fri Sep 03 1999 - 09:39:48 CDT