| 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: Physical Data Layout
Hi,
I will recommend a combination of RAID 1 and RAID 0 over RAID 5 or other RAID's.
Offcourse reading is slower but writing is faster. From your given information, I can
see that I/O is evenly distributed. Never put archived logs and REDO logs in one disk.
same ways index and data should not be clubbed together. I have seen RAID 1 and 0
gives better performance than RAID 5 and also improved performance if we distribute
I/O with different RAID controllers.
HTH
-- On Tue, 24 Apr 2001 23:45:20 Saumya99 wrote:Received on Wed Apr 25 2001 - 11:48:09 CDT
>Hi Chris,
>The concern is the putting datafile on RAID system. Oracle documentation
>recommends not to put datafiles on RAID because reading from a RAID device
>is slower whereas writing is a faster process. Particularly when you are
>thinking of Performance benefit, you can give a consideration here.
>
>-Saumyajit
>
>
>
>
>----- Original Message -----
>To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
>Sent: Wednesday, April 25, 2001 1:22 AM
>
>
>> Hello all,
>>
>> We are moving our production database onto new disks to improve
>> performance. It is a high transction OLTP environment using Oracle8i on
>> a SPARC Solaris box. We are divided about which parts of Oracle to put
>> where for the best performance. We have come up with two basic
>> designs.
>>
>> A-C are SCSI controllers, 0-18 are 36GB hard disks. B & C each are
>> connected to hardware RAID controllers. A has two disks mirrored
>> through software.
>>
>> SETUP I:
>>
>> A0: Solaris & Oracle Software
>> A1: A0 soft mirror
>> B[RAID 0+1]2-9: DATA, SYSTEM, REDO logs
>> C[RAID 0+1]10-17: INDEX, TEMP, Archived REDO logs, TOOLS, ROLLBACK
>> (extra disks used in other systems)
>>
>> SETUP II:
>>
>> A0: Solaris & Oracle Software
>> A1: A0 soft mirror
>> B[RAID 0+1]2-7: DATA
>> B[RAID 1]8-9: REDO logs, SYSTEM
>> C[RAID 0+1]10-15: INDEX, TEMP, Archived REDO Logs, TOOLS
>> C[RAID 1]16-17: ROLLBACK
>>
>> Or is there an even better way to arrange the data?
>>
>> Thanks,
>>
>> Chris
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> --
>> Author: Chris Rezek
>> INET: crezek_at_dotclick.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).
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Saumya99
> INET: saumya99_at_yahoo.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).
>
Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: csvenkata_at_lycos.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).
 |
 |