Re: Do you recommend striping ?

Simon Quinn wrote:
>
> You will see large performance improvements by using Operating system
> level disk striping, especially on table scans.
>
> The best balance is with striping 2 disks across two controllers, this
> adds little (if any) overhead to system administration in the long
> term.
>
> I recently implemented operating system disk striping on Solaris 2.5.1
> on a SUN Enterprise 4000 with 250 concurrent users and we saw at least
> double database performance.
>
> One tip is to use largish O/S striping block sizes, ie 32k-64k.
>
> Forget RAID-5 it doesn't mix well with ORACLE, if you must go RAID
> then RAID-3 will give better performance.

The "performance/reliability experts" at the OAUG conference in Nashville a couple of weeks back said that after all their RAID tests, they have found RAID 0 or RAID 0+1 to have the best performance and data integrity.

• TRW -- |||| remove the underscores in my address to reply |||| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||| | Tim Witort || He is not silent. He is not | | trw_@_medicalert.org || whispering. We are not quiet | | || we are not listening. | | Pin: TZ, only one :^( || - Out of the Grey | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||