Re: Oracle performance under NT

Hi,

Can your provide us NT API calls you used which caused problem. Did all processes used same files or separate ones? I want to check your statement.

Andrew Protasov

> I had a project migrating an OTL (online transaction system) application
> from os2 TO WINDOWS nt4.0
> at ricoh espc in amsterdam holland. NT40 clogged up when about 30 people
> where
> accessing the database concurrently. (adding an extra processor, raid10
> controller,
> and 256meg (yes!) of memory to the machine didn't help at all. Not even a
> slight
> improvement. (I learned the hard way that NT40 isn't scalable.) After close
> examination it seems that NT40 stops when to many processes (28 to be
> exactly) are waiting for blocking IO. The kernel doesn't get any processor
> time at all,
> (flat-line on the task manager monitor)!!
>
> /Jacob
>
>
> Thomas Pall <tpall_at_bga.com> schreef in artikel
> <367847a9.0_at_feed1.realtime.net>...
> > It is entirely possible. However much will depend on how many indexes
> > have to be updated, amount of contention between users, how large your
> > SGN is, how fast and how many CPUs you have. You would certainly want to
>
> > go through the Oracle Server Tuning Manual and do everything you can to
> > speed things up.
> >
> > Michael Ho (hom_at_loyal-holding.com) wrote:
> >
> >
> > : Stephen Vear wrote:
> >
> > : > Does anybody have any performance statistics for Oracle running on NT
> ? We
> > : > are considering a system that will have to perform about 40 table
> inserts
> > : > per second for a period every day. The inserts are about 6
> attributes each.
> > : > We basically want to know whether this sort of performance can be
> achieved
> > : > on an NT platform, or if we need to look to Unix.
> > : >
> > : > Any case histories are appreciated
> > : >
> > : > Stephen Vear
> > : > vears_at_logica.com
> >
> > : 40 table insert is okey for NT. Of course depend on your hardware
> setup,
> > : database design, database size, etc.
> >
> > : General Advice 1 : Never underestimate the system requirement, there
> are always
> > : some later come requirment cost 10 times of your resources.
> > : General Advice 2 : Never undersize your hardware, 'cause it is
> generally cheap
> > : right now.
> >
> >
>
>
Received on Sun Dec 20 1998 - 02:24:35 CST