The Comparison of Sql Server 2000 with Oracle 9i

The comparison of SQL Server 2000 with Oracle 9i

By Alexander Chigrik

Introduction

Often people in newsgroups ask about some comparison of Oracle and Microsoft SQL Server. In this article, I compare SQL Server 2000 with Oracle 9i Database regarding price, performance, platforms supported, SQL dialects and products limits.

Platform comparison

SQL Server 2000 only works on Windows-based platforms, including Windows 9x, Windows NT, Windows 2000 and Windows CE. In comparison with SQL Server 2000, Oracle 9i Database supports all known platforms, including Windows-based platforms, AIX-Based Systems, Compaq Tru64 UNIX, HP 9000 Series HP-UX, Linux Intel, Sun Solaris and so on.

Hardware requirements

To install SQL Server 2000, you should have the Intel or compatible platforms and the following hardware:

Hardware Requirements

Processor Pentium 166 MHz or higher

Memory 32 MB RAM (minimum for Desktop Engine),

64 MB RAM (minimum for all other editions),

128 MB RAM or more recommended

Hard disk space 270 MB (full installation),

250 MB (typical),

95 MB (minimum),

Desktop Engine: 44 MB

Analysis Services: 50 MB minimum and 130 MB typical

English Query: 80 MB

Oracle 9i supports Intel or compatible platforms, AIX-Based Systems, Compaq Tru64 UNIX, HP 9000 Series HP-UX, Linux Intel, Sun Solaris and so on.

To install Oracle 9i under the Intel or compatible platforms, you should have the following hardware:

Hardware Requirements

Processor Pentium 166 MHz or higher

Memory RAM: 128 MB (256 MB recommended)

Virtual Memory: Initial Size 200 MB, Maximum Size 400 MB

Hard disk space 140 MB on the System Drive

plus 4.5 GB for the Oracle Home Drive (FAT)

or 2.8 GB for the Oracle Home Drive (NTFS)

To install Oracle 9i Database under the UNIX Systems, such as AIX-Based Systems, Compaq Tru64 UNIX, HP 9000 Series HP-UX, Linux Intel, and Sun Solaris, you should have the following hardware:

Hardware Requirements

Memory A minimum