Oracle-L: Re: system tablespace with oracle software on same

From: <Peter.McLarty_at_mincom.com>
Date: Wed, 24 Jul 2002 09:08:36 -0800
Message-ID: <F001.004A1120.20020724090836@fatcity.com>

Nah wouldn't do it! Ideally you separate everything that improves performance and recovery chances in the event of a failure and I don't like the idea of having code and data on the same volume spindles. Remember that Oracle has to access the admin part of the tree to write trace files and alert log and probably at time access code that resides on the disk and along with that you want it to keep the dictionary up to date in the system table. I see a potential conflict with that.

My 0.02c US today

Cheers

Peter McLarty               E-mail: Peter.Mclarty_at_mincom.com
Technical Consultant        WWW: http://www.mincom.com
APAC Technical Services     Phone: +61 (0)7 3303 3461
Brisbane,  Australia        Mobile: +61 (0)402 094 238
                            Facsimile: +61 (0)7 3303 3048
=================================================

A great pleasure in life is doing what people say you cannot do.

Walter Bagehot (1826-1877 British Economist)
Mincom "The People, The Experience, The Vision"

This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.

"Carmen Rusu" <carmen.rusu_at_rrc.state.tx.us> Sent by: root_at_fatcity.com
24-07-2002 09:24 AM
Please respond to ORACLE-L

        To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
        cc: 
        Fax to: 
        Subject:        system tablespace with  oracle software on same

Hi Oracle gurus:

Old db question: best db file layout accross filesystems/disks. (unix - Solaris 2.8, Oracle 8.1.7.4)

I have inherited a db file layout recommendation that says to put oracle software and db system tablespaces on the same filesystem /u00/

This is for a production system and it doesnt seem ok to me.

What experiences do you have in your environments with this?

Carmen Rusu

--

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

Author: Carmen Rusu
INET: carmen.rusu_at_rrc.state.tx.us

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:
INET: Peter.McLarty_at_mincom.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