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

From: joe gulla <jgulla_at_erols.com>
Date: Tue, 08 Jun 1999 08:07:49 -0400
Message-ID: <375D0795.496529D7@erols.com>

        As I understand it. Let me know what you think
       If you are asking which is bettor raid implemented striping or manually

striped datafiles , raid implemented striping has several benefits. as data lays out it alternates between one disk then the others , its automatically distributing the io. redo logs, archive logs and possibly indexes should probably be on other non stripped disks, as they are sequential access.

    Manual striping, as I understand it fills the datafile on one disk then the others (less balanced io,more dba activity).

Jerry Gitomer wrote:

> 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 Tue Jun 08 1999 - 07:07:49 CDT