Oracle on NT Performance - again

Hey Oraclers,

Has anybody solved (noticed?) the performance problem with both Oracle 7.1 and 7.3 on NT?

We're experiencing very long response times on our updates. If anyone cared to repeat the following 5min. tests and let me know what you get I would be grateful:

create table test (
fldchar char(30),
fldint integer
)

Create 16 000 rows:
insert into test values ('xxxxx',10);

insert into test select * from test;
Repeat the last statement several times until you come up with 16384 rows

Run and time the following query ( in SQL PLus use "SET TIMING ON"): update test set fldint = 20;

Under Oracle 7.1 the statement took roughly 1min 30sec. to complete. Any changes to SGA or other parameters didn't change things by more than 20%. All statistics information produced by Oracle seemed OK.

Under 7.3 (same machine) the time dropped to 50s.

When we installed MS SQL Server 6.5 trial version and rerun the tests (same machine), the query completed in ... under 3 sec. !!!

I wonder whether it's a rule or an exception...

Our test platform was Windows NT 4.0, 166MHz Pentium with 64MB of RAM

Also if you have any comments against MS SQL Server/ for Oracle or the other way round, I would be glad to hear from you.

Regards,
Pawel Pietrusinski,
pp_at_ciop.waw.pl Received on Fri Feb 06 1998 - 00:00:00 CST