Re: The Best Performance

Paul,

I've found Oracle 8 to be slightly quicker for most pieces of SQL, but never by very much. I've found one or two plans to be slower, but hinting has overcome this problem.

By using the Oracle 8 paritioning features we have greatly improved performance, but this may not be applicable for your system. Best thing to do is set up a test environment and give it a trial.

Steve Phelan.

Paul Brewer wrote in message <8alaUAAlvcV1EwjU_at_pbrewer.demon.co.uk>...
>In article <894553035.28436.0.nnrp-01.c2de712e_at_news.demon.co.uk>, Steve
>Phelan <stevep_at_XXnospamXX.toneline.demon.co.uk> writes
>>Based on the testing I've just done on Oracle 8.0.4 on NT4, I would
suggest
>>that you use striping. Varying SGA parameters (within reason), redo
logging,
>>db block size on db creation, etc., each had less than 10% performance
>>improvement in our datawarehouses. Striping the main data and index files
>>via the NT Disk Admin tool across 3 drives each gave nearly a 300%
>>improvement. Hardware stripping would probably be even faster.
>>
>>Use the NT Performance Monitor to test and profile your system to find the
>>bottlenecks. Oh, and run 'diskperf -y' followed by a re-boot first, or you
>>will not get any disk statistics.
>>
>>Steve Phelan.
>>
>>
>PMFJI. I realise every database is different, but based on your testing
>can you give a quick and dirty summary of 8.0.4 performance on NT4
>against 7.3.3?
>Would really appreciate any comments.
>--
>Paul Brewer
Received on Mon May 11 1998 - 03:18:21 CDT