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:Seeking opinions

Re:Seeking opinions

From: <dgoulet_at_vicr.com>
Date: Tue, 02 Apr 2002 06:23:22 -0800
Message-ID: <F001.00438AF3.20020402062322@fatcity.com>


Paul,

    We kindof use something like that here. Basically when we need to create a database we have the SA create a high level mount point, like '/PS' for our PoepleSoft stuff. We then create additional mount points like say '/PS/pstools' for individual stuff. Disk space is not allocated to '/PS', but to '/PS/pstools'. It does make it easier to find what datafiles are what, but still you'd need to look in the data dictionary. Actually it's faster to look in the data dictionary and you can do it remotely as well.

Dick Goulet

____________________Reply Separator____________________
Author: Paul Baumgartel <treegarden_at_yahoo.com>
Date:       4/1/2002 2:48 PM

Hi everyone.

I'm currently working at a client where the OFA standard has been (as they put it) "taken to the next level". I disagree with their approach, and I'd be interested to see what list members think.

The client believes that any DBA (there are about 16 on staff) should be able to locate data files in any database without querying the data.  To this end, mount points are named both /unnn (e.g., /u001) and /annn (e.g., /a001). "System" datafiles (system, temp, rollback tablespaces) go only on the /unnn mount points, and in particular, datafiles for certain tablespaces must go on certain mount points--for instance rollback tablespace files always go on /u004.

"User" datafiles are allowed on /a001 and /a002, tables and indexes, respectively.

To my mind, this standard changes the Optimal Flexible Architecture to the Sub-optimal Inflexible Architecture, and all just to avoid a data dictionary query. What do you think?

Thanks,



Paul Baumgartel, Adept Computer Associates, Inc. paul.baumgartel_at_aya.yale.edu

Do You Yahoo!?
Yahoo! Greetings - send holiday greetings for Easter, Passover http://greetings.yahoo.com/
--

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

Author: Paul Baumgartel
  INET: treegarden_at_yahoo.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).
--

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

Author:
  INET: dgoulet_at_vicr.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 Tue Apr 02 2002 - 08:23:22 CST

Original text of this message

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