Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RAID

RE: RAID

From: Satar Naghshineh <Satar.Naghshineh_at_irvine.mellesgriot.com>
Date: Fri, 27 Oct 2000 10:20:05 -0700
Message-Id: <10662.120482@fatcity.com>


This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C0403A.2619C960
Content-Type: text/plain

Lee, in that type of environment, you would need a real storage solution like EMC or something similar that can hold that kind of data in a database environment.

Jay, Cache is not always a good thing. The best thing out there is a storage solution that has something called "smart cache" that determines whether to bypass cache and write strictly to disk in a sequential write environment.

Regards,
Satar

> -----Original Message-----
> From: Jay Hostetter [SMTP:jhostetter_at_decommunications.com]
> Sent: Friday, October 27, 2000 2:51 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: RAID
>
> Lee,
>
> I think the consensus is to use Raid 0+1. Our sysadmin claims that our
> disk cache is so large, that it doesn't really matter that we are using
> Raid 5 (we are on Tru64 4.0d). I really don't have the hardware expertise
> or the time to prove otherwise. I wouldn't mind hearing some comments on
> that statement from other folks on the list as they reply to your
> question. I am able to flood the cache during sqlloader runs, but other
> that that, he seems to be correct.
>
>
>
>
>
> Jay Hostetter
> Oracle DBA
> D. & E. Communications
> Ephrata, PA USA
>
> >>> lerobe - Lee Robertson <LEROBE_at_acxiom.co.uk> 10/27/00 08:30AM >>>
> All,
>
> I have seen various threads on the subject of Oracle and Raid but don't
> have
> any messages stored on the subject so forgive me for the repetition
> factor.
>
> Can someone provide a list of do's/don'ts, advantages/disadvantages of
> using
> various raid levels with Oracle (in this case 8) on a TRU64 4.0 platform.
> Database will be approx. 4Tb in size/
>
> Regards
>
> Lee
>
>
> Lee Robertson
> Acxiom
> Tel: 0191 525 7344
> Fax: 0191 525 7007
> Email: lerobe_at_acxiom.co.uk
>
>
>
>

------_=_NextPart_001_01C0403A.2619C960
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUS-ASCII">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">
<TITLE>RE: RAID</TITLE>
</HEAD>
<BODY>

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Lee, in that type of = environment, you would need a real storage solution like EMC or = something similar that can hold that kind of data in a database = environment.</FONT></P>

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Jay, Cache is not = always a good thing. The best thing out there is a storage solution = that has something called &quot;smart cache&quot; that determines = whether to bypass cache and write strictly to disk in a sequential = write environment.</FONT></P>

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Regards,<BR> Satar</FONT>

</P>
<UL>
<P><FONT SIZE=3D1 FACE=3D"Arial">-----Original Message-----</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"Arial">From:&nbsp;&nbsp;</FONT></B> <FONT =
SIZE=3D1 FACE=3D"Arial">Jay Hostetter =
[SMTP:jhostetter_at_decommunications.com]</FONT> <BR><B><FONT SIZE=3D1 FACE=3D"Arial">Sent:&nbsp;&nbsp;</FONT></B> <FONT = SIZE=3D1 FACE=3D"Arial">Friday, October 27, 2000 2:51 PM</FONT> <BR><B><FONT SIZE=3D1 =
FACE=3D"Arial">To:&nbsp;&nbsp;&nbsp;&nbsp;</FONT></B> <FONT SIZE=3D1 = FACE=3D"Arial">Multiple recipients of list ORACLE-L</FONT> <BR><B><FONT SIZE=3D1 =
FACE=3D"Arial">Subject:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</FONT>= </B> <FONT SIZE=3D1 FACE=3D"Arial">Re: RAID</FONT> </P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Lee,</FONT> </P>

<P><FONT SIZE=3D2 FACE=3D"Arial">&nbsp; I think the consensus is to use = Raid 0+1.&nbsp; Our sysadmin claims that our disk cache is so large, = that it doesn't really matter that we are using Raid 5 (we are on Tru64 = 4.0d).&nbsp; I really don't have the hardware expertise or the time to = prove otherwise.&nbsp; I wouldn't mind hearing some comments on that = statement from other folks on the list as they reply to your = question.&nbsp; I am able to flood the cache during sqlloader runs, but = other that that, he seems to be correct.</FONT></P>

<BR>
<BR>
<BR>
<BR>

<P><FONT SIZE=3D2 FACE=3D"Arial">Jay Hostetter</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Oracle DBA</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">D. &amp; E. Communications</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Ephrata, PA&nbsp; USA</FONT> </P>

<P><FONT SIZE=3D2 FACE=3D"Arial">&gt;&gt;&gt; lerobe - Lee Robertson = &lt;LEROBE_at_acxiom.co.uk&gt; 10/27/00 08:30AM &gt;&gt;&gt;</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">All,</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">I have seen various threads on the =
subject of Oracle and Raid but don't have</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">any messages stored on the subject so = forgive me for the repetition factor.</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">Can someone provide a list of = do's/don'ts, advantages/disadvantages of using</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">various raid levels with Oracle (in = this case 8) on a TRU64 4.0 platform.</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">Database will be approx. 4Tb in = size/</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Regards</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Lee</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Lee Robertson </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Acxiom </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Tel:&nbsp;&nbsp;&nbsp; 0191 525 7344 =
</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Fax:&nbsp;&nbsp;&nbsp; 0191 525 7007 =
</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Email: lerobe_at_acxiom.co.uk </FONT> Received on Fri Oct 27 2000 - 12:20:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US