Re: disks for redo logs

From: Michael Austin <maustin_at_firstdbasource.com>
Date: Sun, 15 Feb 2009 23:19:41 -0600
Message-ID: <TH6ml.20491$Ws1.8672_at_nlpi064.nbdc.sbc.com>



helter skelter wrote:
> Hi,
>
> I've got two database - rac and single - and two RAID groups - 4 disks
> in RAID 10 and two disks in RAID 1 on storage array. At this time I'm
> using RAID 10 for RAC database redo and RAID 1 for single instance
> database redo.
> RAC is producing about 100% percent more redo then single db.
> I am wondering if it would be more efficiently to make one RAID 10 from
> 6 disks and use it for both database ? I have no possibilty to test this
> configuration so that is why I am asking You. Thanks for any advices.
>
> cheers

Depending upon your environment - you could investigate the use of ASM instead of cooked file system. In some environments - due to the spread of the data, we get better performance - some not so much...

When choosing to go ASM - there are some concepts that no longer apply to the "device" level. There are some really good books out there on ASM. I like the "Automatic Storage Management - Under the hood" written by the chief developers and development manager with a forward from the chief architect.

When someone says they are using "4 disks" tells me their environment is not very big... :) Our team just finished adding another 120TB to our data warehouse using ASM this weekend. Received on Sun Feb 15 2009 - 23:19:41 CST

Original text of this message