Re: Best RAID Option FOr Oracle DB Files & Redo Logs

        Playing the role of Devil's Advocate I say it depends on what you mean by best. If your concern is performance then RAID0 (striping without mirroring) is best. If your concern is capacity per dollar then RAID5 is the best. If you want a compromise that will give you most of the performance of RAID0 plus a safety net to protect against hardware failure then and only then is RAID10 best.

        Of course if you have enough RAM and a very big SGA, relative to the size of your database, and the proper indexes you can cut disk I/O to the point where it doesn't make any significant difference which you are using.

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 4/20/00, 5:14:55 PM, "George V. Huse, Jr." <buzzhuse_at_flash.net> wrote  

regarding Best RAID Option FOr Oracle DB Files & Redo Logs:

> I say RAID10.
 

> What are other ideas? Official Oracle party line is RAID1 for redo
> logs.
 

> --
> Buzz Huse E-Mail: mailto:buzzhuse_at_flash.net
> Euless, Texas, USA Homepage:
 http://www.flash.net/~buzzhuse/
> "These opinions/comments are entirely my own and no one else's."
Received on Fri Apr 21 2000 - 00:00:00 CDT