Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> OPS on NT (was: Native Oracle-port on Linux)

OPS on NT (was: Native Oracle-port on Linux)

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 1997/12/19
Message-ID: <67d2cp$qlp$1@hermes.is.co.za>#1/1

Jerry Gitomer wrote in message <3499EA5C.E2A_at_p3.net>...
>I have run Oracle on dual, tri, and quad processor NTs and have
>conducted carefully measured benchmarks. I can state with
>assurance that Oracle takes advantage of the additional processors
>when your NT has more than one.

What a relief to have Microsoft's marketing bluh confirmed about NT SMP! :-)

>I built a benchmark able to test the system using anywhere from
>one to eight clients. As you might suspect the time to run a
>single user's workload remains constant no matter how many
>processors are in the box, but when running the workload for
>several users there is a significant difference in the elapsed
>time required to run the workload and there is a direct
>correlation between the number of processors and the performance.
>
>I am not sure, but if Parallel Query (not Parallel Server which
>is an extra cost feature) can be used I suspect that, depending
>on the nature of the workload, there could be differences in
>elapsed time even for the single user.

I agree. Both parallel query and parallel server will be able to provide an increase in performance IMHO. Parallel Query for complex/large SELECT statements will provide increase performance, whereas Parallel Server provides more horses (nodes/cpu's/instances) to pull more users.

The local Oracle Support tech team leader told me that they did an OPS installation with NT. They used Wolfpack and some OEM version of NT and it seems to be working fine. This raises interesting possibilities with NT. My biggest beef with NT has always been the lack of scalability - you need to purchase special OEM versions of NT to scale it to more than 4 processors. And I was doubtful if Wolfpack was an answer. However, if Wolfpack does work and can run Oracle Parallel Server (OPS) then Microsoft may have a very competitive product for large systems. A cluster of 200 Intel Pentium II machines is (almost?) equal to a supercomputer in raw power, and should be much cheaper than a 200 node MPP system from a Unix vendor. Imagine running OPS on that!

But then again, there are questions about how stable and bugfree the initial versions Wolfpack will be and how easy will it be to administer a NT cluster and 200 Oracle OPS instances. The NT commandline sucks and there are no standard telnet with NT.

It will be interesting to see on what type of hardware we run Oracle in 10 years from now...

regards,
Billy Received on Fri Dec 19 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US