Re: Oracle configuration-Raid and Mirroring

From: Don't Bother <davidknollhoff_at_netscape.net>
Date: Mon, 23 Oct 2000 16:09:01 GMT
Message-ID: <8t1nqm$581$1@nnrp1.deja.com>

In some cases, you can have an external disk array which might be faster then some internal disks only if it has hardware raid and hardware cache and is fiber instead of Fast-wide SCSI.

I would not recommend raiding across arrays if you can help it. As far as what type of raid level you should use is really based on what types of applications are ruiing against your database.

A general rule of thumb for me in the past is;

OLTP with heavy updates runs faster with raid 0+1.
Heavy reads will run okay in a raid-5 environment.

This is only a general rule for me but more detailed analysis should be done.

David Knollhoff
Contract Unix Administrator / Oracle DBA

In article <8t1iqj$l5$1_at_nnrp1.deja.com>, sybrandb_at_my-deja.com wrote:
> In article <8t1fa3$trv$1_at_nnrp1.deja.com>,
> ginupfruit_at_my-deja.com wrote:
> > does Oracle support the following configuration?
> >
> > I have a Sun solaris 3500.
> >
> > I have about 50 gig internal Mirrored.
> > Thinking of getting 200 gig external RAID 5 ( need the space)
> >
> > The question is we have two arrays one external and one internal.
How
> > would you recommend to position the Oracle Tables and Objects to
produce
> > the best performance. What is the best configuration of Oracle to
> > satisfy this configuration. Can you raid accros arrays
> > (internal/external) Would you recommend this configuration.
> >
> > Thank you
> >
> > ginup
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
> Whatever you do bear in mind the performance penalty associated with
> RAID-5, which will be lifted only if you have 4+ disks in the array.
>
> Regards,
> --
> Sybrand Bakker, Oracle DBA
>
> All standard disclaimers apply
>

>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

--
Cry on someones elses shoulder


Sent via Deja.com http://www.deja.com/
Before you buy.

Received on Mon Oct 23 2000 - 11:09:01 CDT