Separating tables from indexes is one of those mythical things.
If you want to separate files to different filesystems/volumes/whatever,
do
so based on the amount of IO per file.
disclaimer: I still tend to do that myself, partly by necessity. SAP
demands it,
and it's a starting point on new systems.
Jared
Gudmundur Bjarni Josepsson <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
07/02/2003 02:20 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: Raid 0+1 vs. mirrored pairs
RAID 0+1 and RAID 1+0 provide similar performance but RAID 1+0 has the
advantage of offering more redundancy/availability. If you take your sys
admin's advice and go with 2 x 3 disks in a 0+1 config and you lose one
disk then you lose the other two spindles in that stripe as well. That's
half of your I/O capacity gone. With RAID 1+0 the other two spindles will
still be available when one disk fails in a stripe.
I think it is useful to be able to split your data between different
physical disks. Apart from the fact that redo and archive logs should
never reside on the same volume then it can make a big difference being
able to keep your data tablespaces from your indexes from your rollback
from your redo.
And now I have stated the bleeding obvious. BAARF.
Gudmundur
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gudmundur Bjarni Josepsson
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
