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

Home -> Community -> Usenet -> c.d.o.server -> Re: Appropriate dirve size for Oracle DB

Re: Appropriate dirve size for Oracle DB

From: edipko01 <edipko01_at_home.com>
Date: Thu, 25 Jan 2001 22:52:47 GMT
Message-ID: <3A70BDE1.9010906@home.com>

I understand and agree with everything below, but still have a similar question.

Say you need 36gig of space and only have one scsi channel(40Mbits/s), using 4-9gig drives gives you what you need for capacity and max throughput (4-10Mbit/s drives = 40Mbits/sec).

My question is, since the price difference between 9gig and 18gig drives was only around $50ea., is there any performance (or other) problem using 4-18gig drives? Throughput remains the same up to 72gig now.

Ernie

Dave Paris wrote:

> Mark wrote:
>

>> Greetings,
>> 
>> I recently heard that Oracle performs better with smaller drives in a
>> RAID set (3 Gig to 9 Gig) and a larger drive size of say 32 Gig for
>> each drive is not preferable.  Any truth to this? If so, why?

>
>
> The basic concept here is known as the 'spindle[1] to capacity ratio'.
> The larger the number of spindles and the smaller the amout of capacity,
> given sufficient resources to connect said spindles without inducing a
> bottleneck, will always result in better performance in a RAID 1 or 0+1
> configuration while providing an excellent boost in RAID 5 reads.
>
> This is one of those bizarre mysteries to me .. why do HD companies
> discontinue reasonably-sized drives (4.3G and 9G come to mind) and think
> "Oh, everyone wants our new 2347TB UltraMegaDrive[tm]! Think of how
> much they can put on it!". This seems to be a fairly universal (and
> amazingly stupid) mode of thinking. Other than the A/V industry, I'm
> having trouble coming up with a real, valid use of these monster drives
> where they actually benefit any application.
>
> I'd rather see them get creative and do something along the lines of
> shrinking the case size of the media and putting four 9G drives in the
> space of one 32G drive. (maybe a micro four-channel sub-controller?
> :shrug:)
>
> --dsp
>
>
> [1] the spindle is the cylinder/platter-capture/platter-rotator device
> perpendicular to the orientation of the platters in your hard disk. the
> "drive" in "hard drive", if you will. :)
Received on Thu Jan 25 2001 - 16:52:47 CST

Original text of this message

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