Re: Temp (sort) on Raid 5....

From: Howard J. Rogers <howardjr_at_www.com>
Date: Thu, 26 Oct 2000 21:45:49 +1000
Message-ID: <39f80bac$1@news.iprimus.com.au>

You might want to read what Steve Adams has to say about SAME before recommending it wholeheartedly. Visit www.ixora.com.au

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------

"Viacheslav Leichinsky" <v_leichinsky_at_ittoolbox.com> wrote in message
news:8t8m1a$tb9$1_at_nnrp1.deja.com...


> In article <1tgfvs4ohhigt9djuf0ueg0robs5asa2ca_at_4ax.com>,

>   Doug <zuestra_at_hotmail.com> wrote:

> > Souds like a horrible idea, doesn't it?   But, unfortunately I'm in

> > the position of having to prove it.   Any ideas?  Any way to

> > demonstrate with sysstat or system_event or something that sorting is

> > running like glue?

>

> Hi!

>

> If you turn  write-back cache on, it will be not so bad.

>

> But the last idea from oracle about proper files  distribution is

> SAME (Stripe And Mirroring Everything) methodology. According of

> this one you should put all files (data, index, temp, rbs,

> control and logs!!) on RAID10 ( created by LVM,

> you don't need hardware RAID, only JBOD with write cache)

> with stripe size 1MB, multiblock read size 1MB and max I/O size 1MB !!

> Don't forget place db files on outside tracks of disks.

> It's so easy and unexpensive.  Knowledge, solid background, thoughts

> about proper oracle files distribution are unnecessary for DBA now :)

>

> SAME was introduced by J.Loaiza from Oracle Corp at OpenWorld 2000,

> you can find his presentation on oracle's technet.

> The one citation from this paper:

> "The SAME configuration produces close to optimal performance for ALL

> workloads: OLTP, Warehouse and Batch. We belive that the SAME

> configuration will become the predominant configuration for Oracle

> databases".

>

> Regards,

> Slava.

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.

Received on Thu Oct 26 2000 - 06:45:49 CDT