| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RAID5 - to split or not to split
What about redo logs, rbs, temp, system, exe's?
Number of spindles doesn't necessarly mean faster performance. Depends on the data and the controller. If you set 6 disks with 64 Kb stripe size, your stripe width is 384 Kb with Raid 0. If your not using a write-back caching controller, you will need to use that size transaction or better to fully use the capacity of the volume performance wise. If you send a 32Kb transaction, your only going to use a single disk. Or if you do 400 KB stripe width, your going to write to all the disks once and one disk twice to handle the second set of data in the stripe width.
Size of data, size of stripe size/width are very important in detirmining how many spindles to use and if they will be effective. Using a write-back caching controller (and not saturating it's cache) will generally write out data trying to take advantage of the full stripe width. Reads are effected in this manor as well.
"Walking on water and developing software from a specification are easy if both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
-----Original Message-----
Sent: Friday, June 08, 2001 4:26 PM
To: Multiple recipients of list ORACLE-L
All,
9 drives + hot spare
Would you stripe 6 for data and other 3 for indexes, or use one 9-drive volume for both? One side of me says the more spindles the merrier - keep them together, the other side says - separate data and indexes. The third, evil SA side is waiting for the first two to make up their minds...
Help
Gary Weber
Senior DBA
Charles Jones, LLC
609-530-1144, ext 5529
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gary Weber
INET: gweber_at_cji.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------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).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------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). Received on Fri Jun 08 2001 - 15:39:59 CDT
 |
 |