We experienced something similar to this. Funny the same server running
Oracle on Netware handled the task switching smoother and was less
noticible. We discovered that the application was not taking advantage of
host variables and thus causing every statement to be reparsed, redescribed
etc. Once we fixed that the benchmark went from 22 minutes with 100% CPU
usage (flatline) on NT to 6 minutes with 35% CPU peaks - same machine, same
data etc. Highly repeatable.
Jim
jacob bogers wrote in message <01be2b95$28b00ba0$17e6f1c3_at_msn01>...
>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 - 01:04:20 CST
