Re: system tablespace with oracle software on same

2002-07-24 Thread Peter . McLarty

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: [EMAIL PROTECTED]
Technical ConsultantWWW: http://www.mincom.com
APAC Technical Services Phone: +61 (0)7 3303 3461
Brisbane,  AustraliaMobile: +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" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
24-07-2002 09:24 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).



system tablespace with oracle software on same

2002-07-24 Thread Carmen Rusu

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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).