RE: Hard Drives Configuration, Mirror, RAID5, ETC.

From: Satar Naghshineh <Satar.Naghshineh_at_irvine.mellesgriot.com>
Date: Mon, 9 Oct 2000 14:11:32 -0700
Message-Id: <10644.118831@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_01C03235.7FB06BC0
Content-Type: text/plain

You're right, it really doesn't matter between a 9 gig drive and 18 gig drives that much because the bottleneck will be at the Internal bus of the storage array and server. This is especially true with the technology and speed of hard drives now-a-days. For example, Cheetah has 15000 RPM 18 GB drives. However, depending on your database, you would like to optimize the data access to eliminate any variables during performance tuning.

You failed to explain the nature and type of database (i.e. OLTP database where Performance must be optimized), so it is hard to advise you of what to do.

Good luck,
Satar

> -----Original Message-----
> From: Mario Brenes [SMTP:MBRENES_at_savane.com]
> Sent: Monday, October 09, 2000 10:21 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Hard Drives Configuration, Mirror, RAID5, ETC.
>
> I have a database and I was asked a question that I need some help with:
>
> I know the ideal configuration will be that one where I can have one hard
> drive for each table, index, rollback segment, etc.
>
> Now if I have an external Compaq Storage Unit that allows me to have 14
> hard
> drives,(either 9Gigs or 18 Gigs or 36Gigs) which one is better config and
> WHY??
>
> Lets assume I need 36 Gig of storage:
>
> 1) To buy 4-9Gig hard drives on a MIRROR CONFIG
> 2) To buy 2-18Gig hard drives on a MIRROR CONFIG
>
> Some one told me that the more smallest I buy the best. So even if I buy
> 8-4GIG hard drives it will be better, because the time that the internal
> arm
> that reads each hard drive will take less time covering a 4 gig that the
> time it will take to go thru an 9 Gig or an 18 Gig. I am not talking
> about
> the controllers, I am talking about spindles of each individual hard
> drive.
> I personally think it will not make a big difference and I think the
> bottleneck will be with the controller or controllers accessing all of
> this
> hard drives????
>
> What do you think?????
>
> What it instead Mirror I would have to do the same for RAID5, ,, Which is
> better, I still will think that cost effective also it will be better to
> buy
> BIG hard drives, this way I will not have to buy a new storage unit.????
>
> Please help.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mario Brenes
> INET: MBRENES_at_savane.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (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).

------_=_NextPart_001_01C03235.7FB06BC0
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: Hard Drives Configuration, Mirror, RAID5, ETC.</TITLE>
</HEAD>
<BODY>

You're right, it = really doesn't matter between a 9 gig drive and 18 gig drives that much = because the bottleneck will be at the Internal bus of the storage array = and server. This is especially true with the technology and speed of = hard drives now-a-days. For example, Cheetah has 15000 RPM 18 GB = drives.  However, depending on your database, you would like to = optimize the data access to eliminate any variables during performance = tuning.

You failed to = explain the nature and type of database (i.e. OLTP database where = Performance must be optimized), so it is hard to advise you of what to = do.

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Good luck,</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">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">Mario Brenes [SMTP:MBRENES_at_savane.com] Sent:   Monday, October 09, 2000 10:21 PM To:     Multiple recipients of list ORACLE-L Subject:       = Hard Drives Configuration, Mirror, = RAID5, ETC.

I have a database and I was asked a = question that I need some help with:

I know the ideal configuration will be = that one where I can have one hard drive for each table, index, rollback = segment, etc.

Now if I have an external Compaq = Storage Unit that allows me to have 14 hard drives,(either 9Gigs or 18 Gigs or = 36Gigs) which one is better config and WHY??

Lets assume I need 36 Gig of = storage:

1) To buy 4-9Gig hard drives on a = MIRROR CONFIG
 2) To buy 2-18Gig hard drives on a = MIRROR CONFIG

Some one told me that the more = smallest I buy the best.  So even if I buy 8-4GIG hard drives it will be better, = because the time that the internal arm that reads each hard drive will take = less time covering a 4 gig that the time it will take to go thru an 9 Gig = or an 18 Gig.  I am not talking about the controllers, I am talking about = spindles of each individual hard drive. I personally think it will not make a = big difference and I think the
 bottleneck will be with the = controller or controllers accessing all of this hard drives????

What do you think?????

What it instead Mirror I would have to = do the same for RAID5, ,, Which is better, I still will think that cost = effective also it will be better to buy BIG hard drives, this way I will not = have to buy a new storage unit.????

<P><FONT SIZE=3D2 FACE=3D"Arial">Please help.</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Please see the official ORACLE-L =

FAQ: <A = HREF=3D"http://www.orafaq.com" =
TARGET=3D"_blank">http://www.orafaq.com</A>

<BR><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Author: Mario Brenes</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp; INET: =

MBRENES_at_savane.com

Fat City Network = Services    -- (858) 538-5051  FAX: (858) = 538-5051
 San Diego, = California        -- Public Internet = access / Mailing Lists
 <FONT SIZE=3D2 =

FACE=3D"Arial">---------------------------------------------------------=

-----------
 To REMOVE yourself from this mailing = list, send an E-Mail message
 to: ListGuru_at_fatcity.com (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 Received on Mon Oct 09 2000 - 16:11:32 CDT