Re: Oracle Myths

I suspect it comes from conversations like the ones I have had with my server build folks

How much storage do you need 100GB?
Yes.
Great we can buy 4 72GB disks and put them in a raid5 array. these new ultra scsi 8 12gb cache 20000rpm disks are wonderful!

In other words for most apps people look at capacity only and think that larger capacity disks are a Good Thing TM.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************


"D.Y." <dyou98_at_aol.com> wrote in message
news:f369a0eb.0205221431.35be3d66_at_posting.google.com...


> Daniel Morgan <dmorgan_at_exesolutions.com> wrote in message

news:<3CE953FE.A7538D88_at_exesolutions.com>...


> > Down below in another thread TurkBear wrote: "IMHO, the size does not

matter"


> > with reference to disk size.

> >

> > And this reminded me of another common bit of "wisdom?" with respect to

Oracle I


> > thought I would throw into the mythology pot.

> >

> > For many years I was told that Oracle likes lots of small disks. That

the ideal


> > Oracle system was 100 2GB drives rather than 10 20GB drives. I haven't

heard


> > this repeated in awhile. It was only about 5 years ago I remember a

SysAdmin


> > whining that he could no longer get 4GB drives and would have to move

Oracle to


> > 9GB or 18GB drives.

> >

>

> I guess the thinking behind that argument was really to use disks with

> smaller physical size and thus less seek time, and that somehow got

> translated to less capacity.

>

> > Any commments? Myth or wisdom?

> >

> > Daniel Morgan