Re: Oracle on NT Performance - again

On Fri, 06 Feb 1998 13:04:37 GMT, pp_at_ciop.waw.pl (Pawel Pietrusinski) wrote: Hi Pawel,

checked your example. Our NT-server needs about 16 sec. Check for the size of your redo_logs and setting of redo_log_buffers.

>
>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
>

--

Regards

Matthias Gresz    :-)