Re: spfile vs pfile in 9i

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Sat, 23 Oct 2004 07:53:09 +1000
Message-Id: <4179813a$0$1283$afc38c87@news.optusnet.com.au>

HansF wrote:

> hanges.
>
> IOW, I think the big single advantage of SPFILE comes in a multi-dba shop
> that uses OEM and OMS as a centralized management environment. In that
> environment, the DBAs don't need to coordinate their personal init.ora
> files during 24x7 hand-offs, or remotely log in when restarting database.
> (And yes, I do know that NFS, etc can work around that issue assuming
> security permits that.)
>

I agree. I used the phrase 'no advantages at all' to make a point, but you're right that it's an exaggeration.

The lack of ambiguity about which is the operative configuration file is really a huge plus, and shouldn't be over-looked.

But I phrased my hyperbole with the 'makes things dynamic' and 'can configure more than one instance' claims in mind. I should have put it more carefully.

Regards
HJR Received on Fri Oct 22 2004 - 16:53:09 CDT