Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RAID
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">
<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 "smart cache" 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: </FONT></B> <FONT =SIZE=3D1 FACE=3D"Arial">Jay Hostetter =
<P><FONT SIZE=3D2 FACE=3D"Arial">Lee,</FONT> </P>
<P><FONT SIZE=3D2 FACE=3D"Arial"> 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.</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. & E. Communications</FONT><BR><FONT SIZE=3D2 FACE=3D"Arial">Ephrata, PA USA</FONT> </P>
<P><FONT SIZE=3D2 FACE=3D"Arial">>>> lerobe - Lee Robertson = <LEROBE_at_acxiom.co.uk> 10/27/00 08:30AM >>></FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">All,</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial"> </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"> </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"> </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">Regards</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial"> </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">Lee</FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial"> </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: 0191 525 7344 = </FONT> <BR><FONT SIZE=3D2 FACE=3D"Arial">Fax: 0191 525 7007 =</FONT>
![]() |
![]() |