RE: Seeking opinions

From: Mandal, Ashoke <ashoke.k.mandal_at_medtronic.com>
Date: Tue, 02 Apr 2002 11:08:27 -0800
Message-ID: <F001.00439037.20020402110827@fatcity.com>

Could any of you please summarize all the points once the discussion is over.

Thanks,
Ashoke

-----Original Message-----
Sent: Tuesday, April 02, 2002 11:14 AM
To: Multiple recipients of list ORACLE-L

I agree.

I think that some people don't understand OFA's intentions. First of all, it _is_ a standard, meant to provide great flexibility.

The reason mount points are to be named in a generic fashion is to allow any type of file to reside on them. Any number of file types can happily coexist under their own appropriately named subdirectories.

Under OFA, database files can be easily identified by "ls /u???/oradata/$ORACLE_SID"; the file name ought to include the name of the tablespace to which the file belongs.

Richard's point about a file that gets misnamed is well-taken. The only identification of datafiles that matters is the data dictionary. Rely on anything else and you're asking for trouble.

Thanks to all for their comments.

• "Freeman, Robert " <Robert_Freeman_at_csx.com> wrote:
  > It sounds to me that whoever architected this approach really didn't
  > understand
  > the idea of "metadata" and the flexibility that OFA provides in terms
  > of
  > tuning
  > (I'm not limited to specific disks because I have "customer data")
  > and
  > performance.
  >
  > My 2 cents...
  >
  

  ---

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

---

Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax http://http://taxes.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: Mandal, Ashoke
  INET: ashoke.k.mandal_at_medtronic.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 - 13:08:27 CST