Re: Oracle on NT v. Linux

In article <7aegvs$ue8$1_at_nnrp1.dejanews.com>,   chuckh_at_safeplace.net wrote:
> Has anyone benchmarked Oracle on NT v. Linux on similar hardware? What were
> your results?
>
> Chuck Hamilton
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

I have done very limited testing of Oracle on Linux and NT.

Intel P2 400mhz
10.2 GIG Hard drive
128 MB RAM
Red Hat Linux 5.1
Microsoft WindowsNT4.0 SP3
Oracle 8.0.5

I created identical databases on both with the exact same parameters. For the data I created a single 300MB tablespace. I created a table and loaded it with 3 million rows of data. I used SQL*Load in direct mode. While it took Linux about 3 minutes to load NT only took 1.5 minutes. Once the data was loaded I began to do queries involving full table scans and other things. The time difference was very slight. Linux was only a few seconds (3 at the most) behind WindowsNT. I need to get a hold of some benchmarking tools and do an oficial test.

The initial results are very close but, in my opinion, Linux will ultimately be a better platform. Several times during installation and configuration of Oracle my NT box crashed. Even if Linux and NT are tied as far as performance goes Linux wins on price/performance. I'll continue my tests and try to be objective, but if NT turns out to be the winner by a mile I'm selling all my junk and moving to the islands. I might grow oranges or something.

-b

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Feb 17 1999 - 14:43:23 CST