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

Home -> Community -> Mailing Lists -> Oracle-L -> Advice needed

Advice needed

From: Patrick Van der Sande <patrick.van.der.sande_at_skynet.be>
Date: Fri, 04 Jul 2003 15:30:26 -0700
Message-ID: <F001.005C368B.20030704142424@fatcity.com>


--------------Boundary-00=_6LRIG6G0000000000000 Content-Type: Multipart/Alternative;
  boundary="------------Boundary-00=_6LRIBHK0000000000000"

--------------Boundary-00=_6LRIBHK0000000000000 Content-Type: Text/Plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

=0D
Dear,=0D
=0D
The following machine has been bought but not yet installed : =0D SUN FIRE 6800 =0D
12 CPU a 1,2 Ghz =0D
24 GB Memory =0D
4 X 36 GB internal disks =0D
4 X 14 X 36 GB SAN 15k rpm 2 RAID Controllers (4 T4) =0D Preconfigured with 1 RAID 5 volume & 1 Hot spare =0D 2 GB PCI fibre channel network adapter =0D =0D
Now my concerns and questions : =0D
=0D
1) What RAID architecture must we implement ?? =0D SUN suggest to use RAID 5. At first I do not agree. I always thought RAID 0+1 or RAID 1+0 was better=0D
than RAID 5 certainly for write operations. SUN says the performance will=  be=0D
the same because of the number of disks. Is this true ?? =0D I guess they will spread parity over all disks. =0D =0D
According to SUN we need to invest more, before in our case RAID 0+1 or R= AID
1+0 can be more=0D
performant than RAID 5. I do not know yet what we should invest in. It ha= s
something to do with the connection to the disks.=0D =0D
What about restoring 1 data file ? Since SUN suggest to setup RAID 5 over all disks, is it still possible to restore 1 datafile ?=0D Does somebody know the answers to my questions ?=0D =0D
SUN is coming over on wednesday to discuss SAN config and I want to be prepared. I will not take anything for granted.=0D =0D
2) What about the file systems ? =0D
I know that the more database files are spread over different disks the better. =0D
Two databases will be installed.=0D
I propose the following file systems :=0D =0D

/sid1 --> contains application files and admin directory=0D
/sid1/dbs -> contains datafiles for SYSTEM,UNDO,TEMP & REDO log files.=0D
/sid1/dbs/data -> contains DATA tablespaces datafiles=0D
/sid1/dbs/index --> contains INDEX tablespaces datafiles=0D
/sid1/dbs/arch --> contains archived REDO log files=0D
=0D
The same for sid2.=0D
I want to be certain that sid1 will not influence the performance of sid2= =2E
Sid1 will be production, sid2 will be a test environment.=0D Is this setup possible with RAID 5 ??=0D =0D
Can somebody advice me ?=0D
=0D
Rgds,=0D
=0D
Patrick Van der Sande=0D
Managing Director =0D
ANDES Consulting BVBA=0D
email : [EMAIL PROTECTED]
website : http://www.andes-consulting.be --------------Boundary-00=_6LRIBHK0000000000000 Content-Type: Text/HTML;
  charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-885= 9-1"><html>

<head>
<meta name=3D"GENERATOR" content=3D"IncrediMail 1.0">=0D
<!--IncrdiXMLRemarkStart>
<IncrdiX-Info>
<X-FID>FLAVOR00-NONE-0000-0000-000000000000</X-FID>
<X-FVER>2.0</X-FVER>
<X-CNT>;</X-CNT>
</IncrdiX-Info>
<IncrdiXMLRemarkEnd-->

=0A</head>

<BODY background=3D"" bgColor=3D#ffffff style=3D"BACKGROUND-POSITION: 0px=  0px; FONT-SIZE: 10pt; MARGIN: 1px; FONT-FAMILY: Arial" scroll=3Dyes ORGY= POS=3D"0" X-FVER=3D"2.0">
<TABLE border=3D0 cellPadding=3D0 cellSpacing=3D0 id=3DINCREDIMAINTABLE w= idth=3D"95%">
<TR>

<TD id=3DINCREDITEXTREGION width=3D"100%" style=3D"PADDING-RIGHT: 7px; PA= DDING-LEFT: 7px; FONT-SIZE: 10pt; FONT-FAMILY: Arial"=20

   >

<DIV>&nbsp;</DIV>
<DIV><STRONG>Dear,</STRONG></DIV>
<DIV><STRONG></STRONG>&nbsp;</DIV>
<DIV>The following machine has been bought but not yet installed : =
<BR>SUN=20

      FIRE 6800 <BR>12 CPU a 1,2 Ghz <BR>24 GB Memory <BR>4 X 36 GB inter= nal=20

      disks <BR>4 X 14 X 36 GB SAN 15k rpm 2 RAID Controllers (4 T4)=20

<BR>Preconfigured with 1 RAID 5 volume &amp; 1 Hot spare <BR>2 GB P=
CI=20 fibre channel network adapter <BR><BR>Now my concerns and questions= :=20
<BR></DIV>
<DIV>1) What RAID architecture must we implement ?? <BR>SUN suggest=
to use=20 RAID 5. At first I do not agree. I always thought RAID 0+1 or RAID = 1+0 was=20 better<BR>than RAID 5 certainly for write operations. SUN says the=20 performance will be<BR>the same because of the number of disks. Is = this=20 true ?? <BR>I guess they will spread parity over all=20 disks.&nbsp;<BR></DIV>
<DIV>According to SUN&nbsp;we need to invest more, before in our ca=
se RAID=20 0+1 or RAID 1+0 can be more<BR>performant than RAID 5. I do not kno= w yet=20 what we should invest in. It has something to do with the&nbsp;conn= ection=20 to&nbsp;the disks.</DIV>
<DIV>&nbsp;</DIV>
<DIV>What about restoring 1 data file ? Since SUN suggest to setup =
RAID 5=20 over all disks, is it still possible to restore 1 datafile ?</DIV>
<DIV>Does somebody know the answers to my questions ?</DIV>
<DIV>&nbsp;</DIV>
<DIV>SUN is coming over on wednesday to discuss SAN config and I wa=
nt to=20 be prepared. I will not take anything for granted.<BR></DIV>
<DIV>2) What about the file systems ? <BR>I know that the more data=
base=20 files are spread over different disks the better. <BR>Two databases= will=20 be installed.</DIV>
<DIV>I propose the following file systems :</DIV>
<DIV>&nbsp;</DIV>
<DIV>/sid1 --&gt; contains application files and admin directory</D=
IV>
<DIV>/sid1/dbs -&gt; contains datafiles for SYSTEM,UNDO,TEMP &amp; =
REDO=20 log files.</DIV>
<DIV>/sid1/dbs/data -&gt; contains DATA tablespaces datafiles</DIV>
<DIV>/sid1/dbs/index --&gt; contains INDEX tablespaces datafiles</D=
IV>
<DIV>/sid1/dbs/arch --&gt; contains archived REDO log files</DIV>
<DIV>&nbsp;</DIV>
<DIV>The same for sid2.</DIV>
<DIV>I want to be certain that sid1 will not influence the performa=
nce of=20 sid2. Sid1 will be production, sid2 will be a test environment.</DI= V>
<DIV>Is this setup&nbsp;possible with RAID 5 ??</DIV>
<DIV><BR>Can&nbsp;somebody advice me ?<BR></DIV>
<DIV><STRONG>Rgds,</STRONG></DIV>
<DIV><STRONG></STRONG>&nbsp;</DIV>
<DIV><STRONG>Patrick Van der Sande</STRONG></DIV>
<DIV><STRONG>Managing Director </STRONG></DIV>
<DIV><STRONG>ANDES Consulting BVBA</STRONG></DIV>
<DIV><STRONG>email : </STRONG><A=20
href=3D"mailto:[EMAIL PROTECTED]"><STRONG>patrick.van= [EMAIL PROTECTED]</STRONG></A></DIV>
<DIV><STRONG>website : http://www.andes-consulting.be</STRONG></DIV=
></TD>
</TR>

<TR>
<TD id=3DINCREDIFOOTER width=3D"100%">

=09<TABLE cellPadding=3D0 cellSpacing=3D0 width=3D"100%">
=09<TR>
=09<TD width=3D"100%"></TD>
=09<TD align=3Dmiddle id=3DINCREDISOUND vAlign=3Dbottom></TD>
=09<TD align=3Dmiddle id=3DINCREDIANIM vAlign=3Dbottom></TD>
=09</TR>
=09</TABLE>

</TD>
</TR>

</TABLE><SPAN=20
id=3DIncrediStamp><SPAN dir=3Dltr><FONT face=3D"Arial, Helvetica, sans-se=

rif"=20
size=3D2>____________________________________________________<BR><FONT=20
face=3D"Comic Sans MS" size=3D2><A=20
href=3D"http://www.incredimail.com/redir.asp?ad_id=3D309&amp;lang=3D9"><I=
MG alt=3D""=20
hspace=3D0 src=3D"cid:IMSTP.gif" align=3Dbaseline border=3D0></A>&nbsp;=20 <I>IncrediMail</I> - <B>Email has finally evolved</B> - </FONT><A=20 href=3D"http://www.incredimail.com/redir.asp?ad_id=3D309&amp;lang=3D9"><F= ONT=20
face=3D"Times New Roman" size=3D3><B><U>Click=20 Here</U></B></FONT></A></SPAN></SPAN></FONT> </BODY>
</html>
--------------Boundary-00=_6LRIBHK0000000000000--
--------------Boundary-00=_6LRIG6G0000000000000
Content-Type: image/gif
Content-Transfer-Encoding: base64
Content-ID: <IMSTP.gif>

R0lGODlhFAAPALMIAP9gAM9gAM8vAM9gL/+QL5AvAGAvAP9gL////wAAAAAAAAAAAAAAAAAAAAAA
AAAAACH/C05FVFNDQVBFMi4wAwEAAAAh+QQJFAAIACwAAAAAFAAPAAAEVRDJSaudJuudrxlEKI6B URlCUYyjKpgYAKSgOBSCDEuGDKgrAtC3Q/R+hkPJEDgYCjpKr5A8WK9OaPFZwHoPqm3366VKyeRt E30tVVRscMHDqV/u+AgAIfkEBWQACAAsAAAAABQADwAABBIQyUmrvTjrzbv/YCiOZGmeaAQAIfkE CRQACAAsAgABABAADQAABEoQIUOrpXIOwrsPxiQUheeRAgUA49YNhbCqK1kS9grQhXGAhsDBUJgZ AL2Dcqkk7ogFpvRAokSn0p4PO6UIuUsQggSmFjKXdAgRAQAh+QQFCgAIACwAAAAAFAAPAAAEEhDJ Sau9OOvNu/9gKI5kaZ5oBAAh+QQJFAAIACwCAAEAEAANAAAEShAhQ6ulcg7Cuw/GJBSF55ECBQDj 1g2FsKorWRL2CtCFcYCGwMFQmBkAvYNyqSTuiAWm9ECiRKfSng87pQi5SxCCBKYWMpd0CBEBACH5 BAVkAAgALAAAAAAUAA8AAAQSEMlJq7046827/2AojmRpnmgEADs=

--------------Boundary-00=_6LRIG6G0000000000000--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Patrick Van der Sande
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Fri Jul 04 2003 - 17:30:26 CDT

Original text of this message

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