| 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: Performance tuning
sorry, I should have been clear, here is the quote from the article...
"RAID 5 costs more for write-intensive applications than RAID 1. The
so-called "small-write penalty" inherent in the design of RAID level 5 disk
arrays
makes each Oracle DBWR write require four physical I/O operations.
Conse-quently,
to provide adequate throughput capacity for a write-intensive Oracle
ap-plication,
an architect must use about twice as many disk drives as if he were
using RAID level 1 (mirroring)." - Cary Millsap
-----Original Message-----
Sent: Wednesday, May 30, 2001 1:15 PM
To: Multiple recipients of list ORACLE-L
Yes, Agreed.
Raid of any level will not change the number of writes in terms of DBWR. But will change how many physical reads and writes needed to implement parity and data to the disks.
"Walking on water and developing software from a specification are easy if both are frozen."
Christopher R. Spence
Oracle DBA
Fuelspot
-----Original Message-----
Sent: Wednesday, May 30, 2001 3:02 PM
To: Multiple recipients of list ORACLE-L
No to be overly pedantic, but RAID5 does not change the number of write() calls made by DBWR. It will change the number of disk operations done by your hardware controller or your software raid drivers, but that's slightly different.
> Raid 5 can consume as much as 60% overhead for writes.
>
> "Walking on water and developing software from a specification are easy if
> both are frozen."
>
> Christopher R. Spence
> Oracle DBA
> Fuelspot
>
>
>
> -----Original Message-----
> Sent: Wednesday, May 30, 2001 12:51 PM
> To: Multiple recipients of list ORACLE-L
>
>
> John, have you read Cary Millsap's paper on RAID 5? www.hotsos.com I
> believe. RAID 5 will require additional writes by DBWR which is going to
be
> huge overhead during a dataload.
>
> - Ethan Post
>
> -----Original Message-----
> Sent: Wednesday, May 30, 2001 6:51 AM
> To: Multiple recipients of list ORACLE-L
>
>
> FOR YOUR INFORMATION
>
> ESIS and EPFAL are now part of Logica. The Internet email addresses of the
> staff has changed to the following - lastnameinitial_at_logica.com eg
> SMITHK_at_logica.com. Emails using the old format will continue to be
delivered
> until 30th June 2001.
>
> Peter McLarty wrote
> "Are you running RAID and if so what configuration. (Not RAID 5 I hope)"
>
> Interesting. I am posting an excerpt from Doc 97597.1 Optimising Raid
> performance for Oracle RDBMS on NT
>
> RAID 5 is useful for Oracle datafiles but not for redo log files or
rollback
> segments which are sequentially accessed. Datafiles belonging to the
> temporary tablespace are not suitable for a RAID 5 device. More benefits
> will be seen in situations where reads predominate over writes.
>
> I know that in this instance it is a data load that is being discussed but
> presumably once the data is loaded then it will be read more than once.
>
> Certainly the tone of the note suggests that raid 5 is not a definite
no-no
> rather a 'be cautious as to which files are placed where'. It is my belief
> that often a single raid level is set for all files rather than a mix of
> raid 1 and raid 5 as appropriate.
>
> Peter, I fully agree that the level of memory utilised here is totally
> insufficient and is very likely to be the constraining factor in this
case.
>
> John
>
>
> --------------------------------------------------------------------------
--Received on Wed May 30 2001 - 15:30:32 CDT
> --
> This e-mail is intended for the use of the addressee(s) only and may
contain
> privileged, confidential, or proprietary information that is exempt from
> disclosure under law. If you have received this message in error, please
> inform us promptly by reply e-mail, then delete the e-mail and destroy any
> printed copy. Thank you.
>
>
============================================================================
> ==
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Post, Ethan
> INET: epost_at_kcc.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: Christopher Spence
> INET: cspence_at_FuelSpot.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: George Schlossnagle INET: george_at_omniti.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: Christopher Spence INET: cspence_at_FuelSpot.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). ------------------------------------------------------------------------------ This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. ============================================================================== -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: epost_at_kcc.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).
 |
 |