Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Redo Log Placement - RAID 10 ok?

Re: Redo Log Placement - RAID 10 ok?

From: Joseph Amalraj <joseph_at_amalrajinc.com>
Date: 2006-01-10 15:09:56
Message-id: 20060110140956.60399.qmail@web302.biz.mail.mud.yahoo.com


I think you are saying redo instead on undo.    

  800GB/day is quite a lot. It depends on whether   your i/o subsystem can sustain this throughput. This can be found out from the storage \ vendor.    

  Secondly the redo write rate depends at the rate at which the application commits. Batch \ commits are much better.    

  Another option is trying use use unrecoverable loads, with   selective backup of tablespaces maybe by using split mirror.    

  RAID 10 is recommended. For this redo rate, it is better to allocate   separate set of disks only for redo.    

  Regards    

  Joseph Amalraj   

Edgar Chupit wrote:   

On 1/6/06, Deepak Sharma wrote:
> Is RAID 10 ok for placing Redo Logs?
>
> It's for a very high write-intensive database,
> generating 800G of Undo/Day.
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
Best regards,
Edgar Chupit
callto://edgar.chupit
--
http://www.freelists.org/webpage/oracle-l


  
Received on Tue Jan 10 2006 - 15:09:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US