Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Drive Configuration

RE: Drive Configuration

From: Kevin Kostyszyn <kevin_at_dulcian.com>
Date: Thu, 25 Jan 2001 10:22:42 -0500
Message-Id: <10752.127491@fatcity.com>


Hey I like your configuration, but I do hear that RAID 5 (hardware controlled) is pretty awesome. Can't wait to see what all the DBA's say. Kevin

-----Original Message-----

From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Woody Mckay Sent: Thursday, January 25, 2001 10:02 AM To: Multiple recipients of list ORACLE-L Subject: Drive Configuration

I was asked by some hardware people of my suggested drive configuration for a 5 drive configuration.

I recommended the following:

Drive 1 - Oracle database software
Drive 2 - System tablespace, control file_1, online redo log files
Drive 3 - Roll back (RBS) tablespace, Temp tablespace, control file_2
Drive 4 - Data tablespace, control file_3
Drive 5 - Index tablespace, archived log files

I thought this would optimize the performance of small transactions and small queries. I also thought it would optimize I/O performance by distributing the tablespaces. The database is for a Cold Fusion web site where there will be mostly reads but plenty of writes.

They disregarded this configuration and decided to go with a raid-5 with everything on the single raid for recoverability. I caved in and said ok. Were they right?

Sincerely,

Woody

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Woody Mckay
  INET: wmckay_at_hydrogenmedia.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). Received on Thu Jan 25 2001 - 09:22:42 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US