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: Oracle Performance in Unix machine with hardware Raid 5

RE: Oracle Performance in Unix machine with hardware Raid 5

From: Christopher Spence <cspence_at_FuelSpot.com>
Date: Fri, 17 Aug 2001 07:31:40 -0700
Message-ID: <F001.0036EECA.20010817072154@fatcity.com>

Raid 5 will degrade performance, not many mount points.

You will have contention, but that is not because of mount points or because of the lack of them. It is due to the fact that everything is running on the same set of disks.

Raid 5 takes a big hit on performance, but if that is your only option, you need to see if write performance is suitable enough for what you are trying to accomplish. Although Raid 5 is very slow on write performance, it may be enough to accomplish what you are trying to do as it's read perfomance is good.

"Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax: (707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863  

-----Original Message-----
Sent: Friday, August 17, 2001 10:31 AM
To: Multiple recipients of list ORACLE-L

Hi Guru,

We will be implementing Oracle in unix machine with Hardware Raid 5. We can't implement Raid 1 as we do not have sufficient disk space.

Initially, we thought of having many mount points .ie. 1 mount point for data files, another for index files, other mount points for redo log, control file, archive log etc. The vendor consultant told us that having many mount points may degrade the system performance. Is it true ? We've decided to have different directories for data files, index files etc but I am still worry about data contention.

Any advice ? Thanks.

Regds,
new bee
--

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

Author: CHAN Chor Ling Catherine (CSC)
  INET: clchan_at_nie.edu.sg

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). Received on Fri Aug 17 2001 - 09:31:40 CDT

Original text of this message

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