Re: disks for redo logs
Date: Sun, 15 Feb 2009 23:19:41 -0600
helter skelter wrote:
> 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.
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