473,408 Members | 1,841 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,408 software developers and data experts.

Windows v Unix Performance on Oracle 9i

Rob
Does anyone know if there are any good comparisons between Windows and
Unix performance? Or does anyone have examples of Oracle databases
running large numbers (200+) of concurrent users. I am trying to
investigate what size implementations can be placed onto Windows 2000
/ Windows 2003 as opposed to UNIX but cannot find much data.

Any information would be much appreciated.

Cheers.
Jul 19 '05 #1
3 3580
su**@robtudor.co.uk (Rob) wrote in message news:<cd**************************@posting.google. com>...
Does anyone know if there are any good comparisons between Windows and
Unix performance? Or does anyone have examples of Oracle databases
running large numbers (200+) of concurrent users. I am trying to
investigate what size implementations can be placed onto Windows 2000
/ Windows 2003 as opposed to UNIX but cannot find much data.

Any information would be much appreciated.

Cheers.


As a matter of fact, yes:
http://groups.google.com/groups?hl=e...aead7b6&rnum=2

I also would be interested if anyone is running 200+ actual concurrent
users (not just connections) on Windows. I would find it hard to
believe.

jg
--
@home.com is bogus.
Like using http://www.autoweek.com/specials/gal...glietti_04.htm
as a school bus.
Jul 19 '05 #2

"Joel Garry" <jo********@home.com> wrote in message
news:91*************************@posting.google.co m...
su**@robtudor.co.uk (Rob) wrote in message news:<cd**************************@posting.google. com>...
Does anyone know if there are any good comparisons between Windows and
Unix performance? Or does anyone have examples of Oracle databases
running large numbers (200+) of concurrent users. I am trying to
investigate what size implementations can be placed onto Windows 2000
/ Windows 2003 as opposed to UNIX but cannot find much data.

Any information would be much appreciated.

Cheers.


As a matter of fact, yes:

http://groups.google.com/groups?hl=e...aead7b6&rnum=2
I also would be interested if anyone is running 200+ actual concurrent
users (not just connections) on Windows. I would find it hard to
believe.

jg
--
@home.com is bogus.
Like using http://www.autoweek.com/specials/gal...glietti_04.htm as a school bus.

I think you are going to get better scalability on Unix over Windows. I did
work for a company and we had a very efficient application (bind variables,
cursor reuse - parse once execute many) and were able to get many more than
200+ concurrent users. There are a ton of variables.

How efficient is your application? (scalable)
Is it more OLTP or OLAP? (ours was OLTP by far)
What is the application doing in some sort of work flow for the application?
How many disks?
How much RAM?
....
We were able to load test up to about 1,500 concurrent users on Oracle 8.0
with our application on a very beefy Windows NT box. On Unix we were able
to get a lot more users; our biggest problem was getting enough client
machines so we could test UNIX!
Jim
Jul 19 '05 #3
"Jim Kennedy" <ke****************************@attbi.net> wrote in message news:<Cqhmc.37933$Ik.2505190@attbi_s53>...
"Joel Garry" <jo********@home.com> wrote in message
news:91*************************@posting.google.co m...
su**@robtudor.co.uk (Rob) wrote in message

news:<cd**************************@posting.google. com>...
Does anyone know if there are any good comparisons between Windows and
Unix performance? Or does anyone have examples of Oracle databases
running large numbers (200+) of concurrent users. I am trying to
investigate what size implementations can be placed onto Windows 2000
/ Windows 2003 as opposed to UNIX but cannot find much data.

Any information would be much appreciated.

Cheers.


As a matter of fact, yes:

http://groups.google.com/groups?hl=e...aead7b6&rnum=2

I also would be interested if anyone is running 200+ actual concurrent
users (not just connections) on Windows. I would find it hard to
believe.

jg
--
@home.com is bogus.
Like using

http://www.autoweek.com/specials/gal...glietti_04.htm
as a school bus.

I think you are going to get better scalability on Unix over Windows. I did
work for a company and we had a very efficient application (bind variables,
cursor reuse - parse once execute many) and were able to get many more than
200+ concurrent users. There are a ton of variables.

How efficient is your application? (scalable)
Is it more OLTP or OLAP? (ours was OLTP by far)
What is the application doing in some sort of work flow for the application?
How many disks?
How much RAM?
...
We were able to load test up to about 1,500 concurrent users on Oracle 8.0
with our application on a very beefy Windows NT box. On Unix we were able
to get a lot more users; our biggest problem was getting enough client
machines so we could test UNIX!
Jim


Thanks Jim, I now believe it. In that time frame I wouldn't have even
tried it! I'm still not seeing the performance I would expect given
the hardware, Dual Xeon gigawhateverhertz versus slower multiprocessor
hp's, but the price differential... and what I don't know about
Windows would fill many books... and grid is pushing linux... and I
just haven't personally been able to make any really valid comparison
tests...

The real thing I am troubled by is the idea that commodity hardware
with no good diagnostics and uncertain quality control will affect
databases in unpredictable ways. For example, I have a barely used
W2K OAS10g mid-tier machine that locks up often in the middle of the
night, for no apparent reason. Is there a hardware problem? A
Windows configuration problem (those gazillion updates, what do they
really do)? Does apache make too many files for its poor little file
system? Is there something in Welchia or Sasser that Symantec hasn't
figured out yet? How can I know?

jg
--
@home.com is bogus.
William Herschel, who discovered Uranus, wanted to name it "Georgium
Sidus" after the British King George III.
Jul 19 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Seung Y. Kim | last post by:
Hi everyone. I am having a big performance issue with my ASP application with Oracle database. The application itself is a very database-generic one, so I can switch from Access to SQLServer...
19
by: DW | last post by:
Hi, all... I have a sizeable database running under Oracle 9.2.0.4 under AIX 5.2.0. I am faced with an impending move to a Windows environment, running under SQL 2000. Currently, we are...
10
by: Andrea M. Segovia | last post by:
Hello, I am a newbie to Oracle databases.... We have a visualization front-end tool connected to an Oracle back-end database on a Tru64 UNIX server. We also have clients with MS access...
14
by: tristant | last post by:
Hi All, Our client has just decided to migrate from SQLServer2k to Oracle 9i on AIX. We are considering what development tool / language as the application/ front end platform. We almost...
3
by: Chris Paul | last post by:
I'm having trouble with PHP & PostgreSQL/OpenLDAP/Apache on Windows. I've set this up countless times on BSD (piece of cake) but I'm trying to do this on Windows now so that my developer can work...
0
by: cjeschke | last post by:
On a windows server, I have Oracle installed. I use PROC to precompile .pc code to make a c code file with Oracle calls. I've included every library I can find on the windows Oracle 9.2 environment I...
1
by: Vinod Sadanandan | last post by:
Cross Platform Migration An Unproblematic Approach (Windows-UNIX ) Oracle 10\11g The principal restriction on cross-platform transportable database is that the source and destination platform...
0
by: Mark D Powell | last post by:
getamit23@rediffmail.com (Amit Kapoor) wrote in message news:<c33bca54.0307090046.7698321f@posting.google.com>... The Windows version of sqlplus should be part of the Oracle client install for...
3
by: Rob | last post by:
Does anyone know if there are any good comparisons between Windows and Unix performance? Or does anyone have examples of Oracle databases running large numbers (200+) of concurrent users. I am...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.