Re: Oracle on NT Performance - again

Another thing you may wish to do is have your indexes and tables on separate tablespaces, on different drives?

Brad

Pawel Pietrusinski wrote in message <330f205d.15863320_at_news.ind.mh.se>...
>
>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 Sat Feb 07 1998 - 00:00:00 CST