Re: Physical Layout of disk to use Oracle

Hi,

My previous msg was a bit short and can confusing, let me detail.

OFA specify to have at least 7 area of storage (ideally independent storage volume). I should confess that this is a now a bit too by-the-book since the hardware manufacturer don't want to sell any more small drives and to use a 72GB(or 144GB) drive to hold the archive logs is somewhat expensive.

SAME is a solution that I'm using only for DW that don't have any time constrainsts for load (e.g.: small DW used only 9-5); for any other system I will first separate files with OFA in mind and move them around after some monitoring. Otherwise, I see SAME as a solution for small shop that can't afford a real DBA to monitor files and move them according to DB hot spots.

Also, I agree with Howard (another sub-thread) that SAME should not be confused with the use of RAID-5 that is only acceptable for some specific use (e.g. applications or, in some case, disk backup).

BTW, OFA still of actuallity and has been updated in 1995.

Yannick

On Thu, 18 Sep 2003
22:23:56-0700 Daniel Morgan<damorgan_at_x.washington.edu> wrote:

> Y. Gagnon wrote:
>
> >Hi,
> >
> >By my experience SAME is a cheap trade-off; for more info have a look at
> >BAARF(www.baarf.com) and HotSos (www.hotsos.com).
> >
> >The best way to separate db files are to stay with OFA.
> >
> >Yannick
> >
> >On Tue, 16 Sep 2003 13:40:45+0200"MK"<MK_at_foo.com> wrote:
> >
> >
> >
> >>"Hari Om" <hari_om_at_hotmail.com> wrote
> >>
> >>[...]
> >>
> >>
> >>I've just returned from a database-related conference.
> >>There was I nice paper, describing how to
> >>approach physical layout for the highest
> >>THROUGHPUT of any configuration: stripe (and
> >>mirror, if possible) everything. Also, don't separate
> >>indexes and data.
> >>
> >>
> >>
> OFA has nothing to do with it. And OFA was developed for Oracle 7 which
> a long time before the hardware, operating systems, and large systems we
> deal with today.
>
> OFA is fine for many aspects of layout. But I certainly wouldn't ask it
> to do what it was never intended to address.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Fri Sep 19 2003 - 06:35:31 CDT