|
For optimal performance on an Oracle database a combination of RAID levels and database component placement works well.
If you are using multiple controllers, build a volume groups by concatenating logical volumes across controllers. For most large cache storage controllers it is not required to strip the database itself, but indexes will benefit from software striping. So RAID 1 should be used for the database and RAID 10 for indexes and log files.
Logs should be spread across controllers and striped. Archive files can be placed on logical drives to fill up physicals and flatten the access density on all drives. If available, the archive logs can be placed on larger or slower drives.
Hope this helps.
Jim
Editor's note: Do you agree with this expert's response? If you have more to share, post it in our Administrator Central forum at http://searchstorage.discussions.techtarget.com/WebX?50@@.ee83ce2 or e-mail us directly at editor@searchstorage.com.
|