Re: The Best Performance

From: Steve Phelan <stevep_at_XXnospamXX.toneline.demon.co.uk>
Date: Thu, 7 May 1998 15:57:33 +0100
Message-ID: <894553035.28436.0.nnrp-01.c2de712e@news.demon.co.uk>

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.

Jener R. Silva wrote in message <6i22eu$a54_at_news.dot.gov>...
>Given the following machine config:
>
>Quad Pentium PRO 200 Mhz
>256 MB RAM
>Windows NT 4.0
>Oracle 8
>Adaptec AHA-3940UW SCSI
>
>Drive C: 2 GB
>Drive D: 4 GB
>Drive E: 4 GB
>Drive F: 4 GB
>Drive G: 9 GB
>Drive H: 9 GB
>Drive I: 9 GB
>
>What would be the best installation approach?
>I have a large amount of data to store; mostly DSS system no OLTP
>transactions.
>Should I increase the RAM?
>Should I create SYSTEM tablespace on drive C: and use the other ones for
>DATA, INDEXES, TEMP, and ROLLBACK?
>
>
>
Received on Thu May 07 1998 - 09:57:33 CDT