Re: Opinions on SAME?

Steve Cole wrote:
>
> Assuming you have the disks, of course.
>
> The question is this:
>
> You have 8 disks to use. How would you use them?
> A) All 8 in RAID 0+1
> B) 6 disks in RAID 0+1 and 2 disks in RAID1 for redo logs.
>
> Nuno Souto wrote:
> >
> > On Wed, 18 Apr 2001 08:41:59 -0400, Steve Cole <scole_at_fmgtech.com>
> > wrote:
> >
> > >I have to question putting the redo logs into that mix though. Redo is
> > >sequential writes, the other components are random access. I have to
> > >think that keeping the redo on a separate hardware RAID 1 by itself
> > >would be faster than putting it on the RAID 0+1 with everything else.
> > >
> >
> > Sure. If you got the disks to do that, do it! If not, use SAME.
> >
> > Cheers
> > Nuno Souto
> > nsouto_at_bigpond.net.au.nospam
> > http://www.users.bigpond.net.au/the_Den/index.html

"Depends" (standard answer of course)...

For an 8-disk solution on a massively read-biased database, I would choose (A), for a massively update-biased database, I'd be looking at (B).

hth
connor

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"