Re: RAID 0 or manual striping - which is better?

Hi,

    IMHO, since you don't want mirroring you are better off without striping. This will give you better control over where redo logs, archive logs, data files, etc are located on your system. If you do decide to mirror you can get much better performance if you move your redo logs and your archive logs off of the mirror set. Also you really want your indexes in a different tablespace and on a different disk drive than the tables they index.

    You should go out and buy a copy of Kevin Loney's Oracle DBA Handbook, Oracle Press Osborne/McGraw-Hill (be sure to get the Oracle 8 version with the red and Grey cover).

regards

Jerry Gitomer

coakleyj_at_hotmail.com wrote in message <7j63rb$grt$1_at_nnrp1.deja.com>...
>Hi everyone.
>
>I'm purchasing an NT box for Oracle 8.1.5.
>I have the option for RAID 0 or no RAID at all.
>Availability is not an issue, so we are not considering
>mirroring.
>
>So, in general, for an Oracle application, does RAID0
>achieve good performance with its striping, or is manually
>placing the various database files on the appropriate disks
>better?
>
>I know this is a bit of a "How long is a piece of string", but I
>need ideas and guidelines.
>
>Much appreciated - Thanks Coakleyj
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Thu Jun 03 1999 - 14:44:42 CDT