Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Configuring Oracle with RAID and OFA
FWIW, we've got an 8.1.7 system set up on Solaris8. The whole whopping 6GB
of datafiles are spread across a 6-wide RAID 0+1, with redos and archives on
their own 0+1s.
Our hotbacks take 90 seconds.
OTOH, our 28GB ERP system on an HP AutoRAID 12H takes over 2.5 hours. I'd like to be done with that in 7 minutes, extrapolating from our other system, not to mention the performance increase for our users (system-wide waits average in the 100s during the day due to physical I/O, but that's a whole other kettle of worms).
:)
Rich
Rich Jesse System/Database Administrator rich.jesse_at_qtiworld.com Quad/Tech International, Sussex, WI USA
-----Original Message-----
Sent: Thursday, March 27, 2003 1:29 PM
To: Multiple recipients of list ORACLE-L
don't remember how many physical disks we had in that set. Depends on how things are being used really. I'd love redo on at least two disks, so that the files being archived are not competing with the files being written to.
RAID 1+0 on as many disks as I could, binaries on the internal system
disks, spread the tablespaces around depending on what was hot or not
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jesse, Rich
INET: Rich.Jesse_at_qtiworld.com
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: 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 Thu Mar 27 2003 - 15:19:05 CST
![]() |
![]() |