RE: Oracle Performance in Unix machine with hardware Raid 5

From: April Wells <awells_at_csedge.com>
Date: Fri, 17 Aug 2001 07:47:38 -0700
Message-ID: <F001.0036EEFA.20010817072156@fatcity.com>

We raid 5 on an AIX box, we have 89 mount points for database files (data and or index) as well as mount points for different kinds of scripts and files, redo and archival. We had one problems with Fork Function Failed for a while, Oracle said it was AIX, IBM said it was Oracle. We upped the paging space significantly and haven't had any problems since. Ours is more of an ODS/Reporting/Pre datawarehouse kind of environment, use loader to incrementally update every night with datafiles from the OLTP Datacom databases on the Mainframe... so in an OLTP I can't say for sure if you will find problems.

April Wells
Corporate Systems
Amarillo Texas
-----Original Message-----
Sent: Friday, August 17, 2001 9: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).

The information contained in this e-mail is strictly confidential and for the intended use of the addressee only; it may also be legally privileged and/or price sensitive. Notice is hereby given that any disclosure, use or copying of the information by anyone other than the intended recipient is prohibited and may be illegal. If you have received this message in error, please notify the sender immediately by return e-mail.

Corporate Systems, Inc. has taken every reasonable precaution to ensure that any attachment to this e-mail has been swept for viruses. We accept no liability for any damage sustained as a result of software viruses and advise you carry out your own virus checks before opening any attachment.

--

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

Author: April Wells
INET: awells_at_csedge.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------