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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Christopher Spence
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
