Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> dedicated spindles and Oracle
I was talking to an Oracle guy who also works with SANs. This is what he told me. For optimal performance do the following
2 redo log groups each with dedicated spindles 2 archive logs each with dedicated spindles
data data files have their own dedicates spindles with several lines and spread the data files out index data files do the same thing but have their own dedicated spindles
control files can be placed on the same spindles as data files, however, check point activity on systems with large numbers of data files especially when doing hot backups may require control files having their own dedicated spindles.
What is your opinion? Is there any way to estimate a good starting point to test LUN sizes for performance? Not sure what sizes I should ask for to begin my performance tests. I was thinking of running bench marks with several different sized LUNs.
-- http://www.freelists.org/webpage/oracle-lReceived on Sat Sep 15 2007 - 15:30:36 CDT