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?
IMHO -- Mark D Powell --
-- --Original Message-- --
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)]On Behalf Of Nuno Souto
Sent: Thursday, May 06, 2004 6:51 AM
To: oracle-l@(protected)
Subject: Re: More spfile goodness
> The SPFILE is needed more and more with new releases. Handling some of
the=
Correction:
Oracle IS making use of the SPFILE more and more mandatory. There is
NO REASON whatsoever why it can 't be for example an XML file
and still retain exactly and precisely the same functionality.
> automatic memory management and so on can 't be kept across instance
shutdo=
> wns without using the SPFILE.
Exactly and precisely *why*?
> I honestly can 't see why people are so against using it. I 've had this
con=
Because they see no advantage whatsoever in introducing an additional level
of risk with yet another cryptic binary file, for no perceived gain
whatsoever
other than Oracle having decided "it should be so "?
> Exact same way you 'd need to do it with a corrupted pfile I suppose. And
o=
With the minor exception that text files like pfile do NOT get "corrupted "
EVER? Stick with tried and true, rather than misadventures please?
Cheers
Nuno Souto
in sunny Sydney, Australia
dbvision@(protected)
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
