473,403 Members | 2,071 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,403 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 3579
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: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
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...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
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
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
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
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

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.