The redo log plays a prime role in Oracle database’s core functionality. However it imposes disk i/o for the redo log’s inherent functionality, increased i/o can highly affect the Oracle performance. This paper analyze the performance issues related to the Oracle redo log, and solutions to address those issues, also covering how to minimize the overhead of redo logs and improve the overall database performance.
As EMC best practice and test report, redo log write in most scenarios are able to handle with VNX SP write cache, because the pattern of redo log write is small seq write.
Though SSD is not typical for small seq write, it is great for high-bandwidth I/O components such as Oracle redo logs. Some test showed when you are not CPU constrained, moving the online redo to high-speed solid-state disk can make a difference. Certainly the price is a difference also.
Hi Charlie, the RAID type does provide balance of system reliability and performance. RAID 1 or 0+1 are recommended to achieve optimal redo log performance in additional to good system reliability
I wrote a blogpost on redo log performance as this is a recurring topic in many customer discussions.
Disclaimer: not everyone might agree with my statements (but I guess that's normal when discussing performance stuff )
Bottom line is that storage cache should handle all redo writes, therefore your response time should be very low (if not, something is wrong). RAID-5 should be fine for performance as redo log writes almost 100% sequential which is very spinning disk friendly. IMO the only reason to have RAID-1 for REDO is availability (another discussion) and (maybe) if you have very excessive write workloads.
But having other data (TEMP, DATA, INDEX, etc) on the same physical disks as the REDO logs breaks the whole thing (disks start doing random seeks and this slows down REDO updates, and the REDO updates then cause high disk utilization which slows down random reads for DATA in return). Hard to diagnose.
reseach
2 Intern
•
225 Posts
1483
0
Posted June 6th, 2012 00:00
Do you experience any redo log writer issues?
As EMC best practice and test report, redo log write in most scenarios are able to handle with VNX SP write cache, because the pattern of redo log write is small seq write.