Re: NT vs. Unix

From: Gjlinker <gjlinker_at_aol.com>
Date: 14 Feb 1999 16:33:32 GMT
Message-ID: <19990214113332.16677.00000627@ngol03.aol.com>

Dear all,

>Has any one compiled a list of pros and cons of installing/running
>Oracle on each platform (NT and Unix (any flavor of unix))?

I don't have a list but I thought you might be interested in my findings with NT last week.

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.

Solution:
Have a dedicated box for Oracle. This rendered a cpu max of about 30-50% under the same conditions, the VB apps running on a different machine taking about 30-40% of a single CPU P166 machine.

Regards Gerrit-Jan Linker,

---

*| Gerrit-Jan Linker : gjlinker_at_aol.com
*| 
*| http://members.aol.com/gjlinker

*| 
*| Developer of:
*| Oraxcel, OraWeb, OraSQL, OraCodes and OraDebug
*************************************************
LLLL      IIII  TTTTTTTTTTTT
LLLL      IIII  TTTTTTTTTTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT

LLLL

LLLLLLLLLLLLLLLLLLLLLLLLLLLL

L Linker IT Consulting Ltd L

LLLLLLLLLLLLLLLLLLLLLLLLLLLL

Received on Sun Feb 14 1999 - 10:33:32 CST