Re: spfile vs pfile in 9i

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Thu, 28 Oct 2004 05:10:34 +1000
Message-ID: <417ff299$0$22631$afc38c87@news.optusnet.com.au>

e_a_olson wrote:

> My understanding from my Oracle coursework is the the spfile is
> managed by Oracle, and is basically Oracle's representation of
> init.ora. I'm confused as to why people are talking about modifying
> the spfile, as we were told this was a no-no. Please enlighten me.

Depends, I think, what you mean by the word "modifying".

This is completely, utterly and 100% legal, valid:

"Alter system set shared_pool_size=100M scope=spfile;"

...and you've just modified the spfile.

If you mean: open it in notepad and start typing, totally a no-no, I agree.

Regards
HJR
> -Eric
Received on Wed Oct 27 2004 - 14:10:34 CDT