Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: stripe the log file across different disks?
Steve has an a detailed artical on his website....
http://www.ixora.com.au/tips/creation/online_log_files.htm
Rgds, Ken Heng
IBM GSA - Oracle DBA
Level 32, 201 Elizabeth Street
Sydney, NSW 2000
Phone : 02-9396 8298
Mobile : 0401-144 794
Email : kheng_at_au1.ibm.com
"chao_ping" <chao_ping_at_vip.16 To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> 3.com> cc: Sent by: Subject: stripe the log file across different disks? root_at_fatcity.com 10/01/2003 03:58 pm Please respond to ORACLE-L hi, friends: From many oracle tuning manual, I found words like stripe the redo log on different disks, this should boost redo performance. But according to my experience, every single redo write(thissize should not be much larger than average transaction redo) is always quite small,and it seems that most raid system give the stripe size much larger than this single write.
So , according to your experience, does stripe redo log files across different disks really helps performance?
Thanks.
Regards
zhu chao
msn:chao_ping_at_163.com
www.happyit.net
www.cnoug.org(ChinaOracle User Group)
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: chao_ping INET: chao_ping_at_vip.163.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-LReceived on Fri Jan 10 2003 - 00:28:39 CST
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ken Heng INET: kheng_at_au1.ibm.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).