Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: NT vs. Unix

Re: NT vs. Unix

From: Colin Smith <Colin_Smith_at_euro.css.mot.com>
Date: Mon, 15 Feb 1999 15:16:45 +0000
Message-ID: <36C83A5D.C9B9188E@euro.css.mot.com>

Walter Dnes wrote:

> On 14 Feb 1999 16:33:32 GMT, gjlinker_at_aol.com (Gjlinker) wrote:
>
> >Environment:
> >Compac server dual processor P200
> >NT4 + Oracle 7.3 + 600 MB memory + 4 GB disk
> >10 users selecting 100 rows from a 150.000 row table using indexes.
> >15 VB programs connected via ODBC running on the server.
> >
> >Result:
> >Processors busy for most of the time 75-100%
> >Very slow performance due to high write times of Oracle.
> >
> >Analysis:
> >Apparently PC hardware does not write to disk when processor is busy over 80%
> >creating huge write times in Oracle.
>
> One thing I don't see mentioned... does the machine have a
> full-fledged Ultra-Wide SCSI disk drive, or is drive a cheap-o
> level-1 EIDE where the CPU has to babysit each byte being
> read or written from/to the drive? SCSI drives aren't
> mechanically faster, but they do have their own chips to
> handle scatter/gather, and do requested operations on their

Actually most SCSI drives run at 10,000 rpm while most IDE drives are still running at 5400 rpm. Hence the price difference.

It might be worth your while benchmarking Oracle/Linux on the same box as well.

--
Colin Smith
Cellular Subscriber Sector Europe
Colin_Smith_at_euro.css.mot.com
Phone: +44 (0)1256 790 261 Received on Mon Feb 15 1999 - 09:16:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US