RE: More spfile goodness
- From: "Cary Millsap" <cary.millsap@xxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 7 May 2004 08:13:13 -0500
Pete,
You can add me to the "binary pfile haters club" list as well. Looks =
like
I'm in good company.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *
Upcoming events:
- Performance Diagnosis 101: 5/7 Dallas, 5/18 New Jersey, 6/22 =
Pittsburgh
- SQL Optimization 101: 5/3 Boston, 5/24 San Diego, 6/14 Chicago
- Hotsos Symposium 2005: March 6-10 Dallas
- Visit www.hotsos.com for schedule details...
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Nuno Souto
Sent: Friday, May 07, 2004 5:06 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: More spfile goodness
----- Original Message -----=20
From: "Pete Sharman" <peter.sharman@xxxxxxxxxx>
> And if it was an XML file would you still complain so vociferously? =
:)
Not at all. Config files are if anything the perfect application for
XML.
> I think the point of not making the SPFILE directly editable is just a
secu=3D
> rity thing.
No way! Security is one thing, provided by the OS. Obfuscation is
a totally different one, provided by Oracle with the SPFILE, by M$ with
the silly registry "hives" and by just about NOBODY else. Because as
an excuse for "security", it's worn out ages ago...
> As T. Rex (also known as T. Gorman) mentioned in a different r=3D
> esponse, I can see more and more things being done based on the need =
to
mak=3D
> e life easier 1. for the DBA's and 2. for the people who have to look
after=3D
> a database that aren't a DBA's rear end (of which we're seeing more =
and
mo=3D
> re, don't you agree?) =3D
Absolutely. Now please: in what way does that make using XML for config
files (instead of binary) less desirable? Or text for that matter?
I don't recall "end users" reading ANY files, let alone XML or binary or
text. Bugger, they can't read a screen unless it has a "rich =
multimedia"
interface, whatever the heck that means!
Let alone care what format is used behind the scenes? "What's a format
and why do I need one" is the general attitude we're dealing with =
here...
That has got NOTHING to do with the technique used to store the data. =
The
two things are not related in any way shape or format.
Or do you seriously think when a rep approaches a prospect and 'splains
Oracle is "secure and easy to use" because its config is binary, (s)he =
is
not gonna get laughed at? Like: who cares?
> For the actual details of WHY an SPFILE was created in binary form, =
you'd
n=3D
> eed to talk to the developer who made that decision. Not me, no idea =
who
i=3D
I'd like to think Oracle has grown big enough to go past the stage where
developers made such decisions. SOMEONE must be in charge of overall
design,
unlike in the bad old days. This can't be just a duhveloper...
>t is. My whole point with the SPFILE is that for some reason, there =
are
pe=3D
>ople like hjr and Nuno (and now I have to add Tim to the list ;) who =
have
a=3D
> deep philosophical disagreement with the existence of the SPFILE. I'm
too=3D
I couldn't care less if it is called SPFILE or BURGERFILE, quite =
frankly.
As for the format, make it "transversely-proportional with =
multi-dimensional
crystallography", for all I care.
But do NOT leave me with a half-baked solution where I end up having to
maintain
TWO files, one the weirdo with weirder bugs, the other good old text! =
And
if you
have to change something that has worked perfectly for eons, then do so
using
modern technology and design, not mainframe obfuscation!
That's the depth of my philosophy for today.
> That's three emails in an hour I've diss'ed Nuno on now, I better D&R =
very
=3D
> very fast! ;)
You can run. But you can't hide! :)
Cheers
Nuno Souto
in sunny Sydney, Australia
dbvision@xxxxxxxxxxxxxxx
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
