Re: Linux vs. Windows performance.

From: Chuck <chuckh_nospam_at_softhome.net>
Date: 20 Feb 2004 14:27:22 GMT
Message-ID: <Xns9495603129A18chuckhsofthomenet@130.133.1.4>

drak0nian_at_yahoo.com (Paul Drake) wrote in news:1ac7c7b3.0402192210.7118003d_at_posting.google.com:

> Chuck <chuckh_nospam_at_softhome.net> wrote in message
> news:<Xns9493A2686350Bchuckhsofthomenet_at_130.133.1.4>...

>> Michael Rothwell <marothwellRemoveThis_at_yahoo.com> wrote in
>> news:GeqdnbRkYfsyubDdRVn-hg_at_comcast.com: 
>> 
>> > Has anyone taken an Identical Windows box and Linux box (same
>> > hardware configuration) and tested Oracle performance?  I'm looking
>> > for some real world examples if I move from Windows 2k to linux
>> > with Oracle 9i. 
>> >  The box currently has 2 1.8 CPUs with 4 disks and 1 G ram.  OLTP
>> > system with tables using about 30 G of space.  About 40 - 100
>> > concurrent users, but this may double soon.  Can I expect better
>> > performance from the Linux box? 
>> > 
>> > Thanks
>> > 
>> > Michael
>> > 
>> 
>> I have not run Oracle on Linux but I have on Windows, AIX, HPUX,
>> IRIX, Novell and SunOs over the past 9 years. 10% of my databases are
>> on Windows and they easily account for 90% of the problems - memory
>> that doesn't get released, process that get orphaned and must be
>> manually cleaned up, threads that get orphaned and cannot be cleaned
>> up apart from a reboot. I am looking forward to running Oracle on
>> Linux perhaps in the next year or two just as soon as I can convince
>> management that Windows is a crappy platform for Oracle.
>> 
>> The only problems I encounter with Oracle on Unix are those
>> introduced by application code.

>
> If I could ask for one feature to have working for Oracle on win32, it
> would be dead connection detection. It was advertised to work in the
> 9.2.0.4 patchset, but did not. Maybe there will be a silver lining in
> 9.2.0.4 patchset 3 and DCD will work there. Maybe it will be in
> 9.2.0.5, or 10.1.0.2.0.
>
> Or maybe we'll see such a rash of vulnerabilities due to the source
> code release of a certain operating system that oracle on win32 will
> be abandoned. :)
>
> Pd
>

It was supposed to work on 8.1.5, 8.1.6 (what a horrible release), and 8.1.7 as well. In fact, way back on 8.1.5 (2 years ago maybe) I was told by Oracle Tech.Support to enable DCD and that would fix my orphaned threads problem. It did not. About a month ago, they told me it was the cause of my orphaned threads problem, disable it and that would fix the same problem. It did not. I wish I could simply move all these Win2k instances to unix but the vendor will not support the application on any platform but win2k. :-(

-- 
Chuck
Remove "_nospam" to reply by email

Received on Fri Feb 20 2004 - 08:27:22 CST