Re: Oracle performance under Windows 2000 vs. UNIX

patonp_at_yahoo.com (Peter) wrote in message news:<b5d22001.0302141304.169fd1a0_at_posting.google.com>...
> I've got a simple question here that requires a more complex answer:
> On which type of platform will Oracle run faster given the same
> hardware: UNIX or Windows 2000? (I'm particularly interested in
> understanding what in the architecture of Oracle and the two products
> results in this difference). Also, just how customized is Oracle for
> the specific O/S (i.e. how much of the code base is shared)?
>
> Thanks to anyone who can help!
>
> Peter

Oracle uses a Virtual Operating System layer, much like Unix. There wouldn't be that much of customization, as they have tried to hide the O/S specific features by using the VOS (See James Morle, Scaling Oracle 8i for further details)

By design the scalability of NT/Win2k is limited, and basically you won't get beyond the 2G in the standard edition of NT. Half of the RAM is by design reserved for the O/S and you won't see this on any Unix implementation.
Also before WinXP there was a limit of 16 timers per process for Winblows, this meant you basically couldn't use Net8 dead connection detection, unless you had less than 16 connections.

Regards

Sybrand Bakker
Senior Oracle DBA Received on Mon Feb 17 2003 - 09:45:34 CET