RE: More spfile goodness

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Thu, 6 May 2004 10:28:56 -0500
Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B00599@EXCHMN3>

Two speculations (since I'm not part of that Oracle design group):

1. One of the purposes of the SPFILE was to be able to have the same SPFILE on every server, to support the surge toward grid computing. I think that is why they didn't move some of these parameters to the control file.
2. Microsoft seems to be moving away from simple, editable files toward files that have a GUI interface. And often Oracle is forced to appear as "user friendly" as MS. If you've ever designed an interface for many customer sites to use, you tend to get a little paranoid. Inevitably some person somewhere will scramble the plain text file beyond what you anticipated and then you the developer are tagged with having caused a "bug". Having a file the strange people can't legitimately edit (although some clever people on this list have done just that) makes the developer feel a little more comfortable. Sorry if I've spoiled anyone's rant, it is just my nature to seek to understand the reasons behind the actions of others.

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Nuno Souto Sent: Thursday, May 06, 2004 9:55 AM
To: oracle-l_at_freelists.org
Subject: Re: More spfile goodness

Why complicate things indeed? If it had to be a binary file, it could well have been the control file as you suggest. All this spfile/pfile rigmarole is just an unnecessary and unwarranted complication. But it's great to generate revenue out of OCP training...
Cheers
Nuno Souto
in sunny Sydney, Australia
dbvision_at_optusnet.com.au
----- Original Message -----
From: "Powell, Mark D" <mark.powell_at_eds.com> To: <oracle-l_at_freelists.org>
Sent: Thursday, May 06, 2004 10:47 PM
Subject: RE: More spfile goodness

> I have no problem with the concept of an spfile to hold database
parameters,
> but I wonder why Oracle did not use the existing control file. After all
> where else does control information belong?
>

---

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

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu May 06 2004 - 11:03:39 CDT