Re: spfile vs pfile in 9i

From: Fabrizio <fabrizio.magni_at_mycontinent.com>
Date: Sat, 23 Oct 2004 09:14:41 GMT
Message-ID: <417A2102.5050701@mycontinent.com>

Howard J. Rogers wrote:

> Howard J. Rogers wrote:
> 
> 

>>Fabrizio wrote:
>>>In a spfile I miss the old-fashioned comments who could be added in a
>>>pfile. :(
>>
>>First, comments should never be in the init.ora. They make it extremely
>>hard to read, and I well recall the 33-page one I had to wade through not
>>a million years ago: every damn parameter preceeded by comments such as
>>"I, Fred, was authorised by Wilma to increase the shared pool to 160MB.
>>This was because of blah-de-blah-de-blah". You could never tell whether a
>>line in the file was actually setting something or was merely the start of
>>another essay on the meaning of life as seen by Fred.
>>
>>Yuk, yuk, yuk. The init.ora should be short, sharp and functional. Keep
>>change management (and change history) out of it.
>>
>>Second, you can of course add comments into the spfile (each new comment
>>over-writing the last for any given parameter).
>>
>>alter system set shared_pool_size=80M comment='I, Fred, am a wally'
>>scope=spfile sid='*';
>>
>>Regards
>>HJR

> 
> 
> 
> Oh, and I meant to add: the comments are then visible in the UPDATE_COMMENT
> column of v$spparameter.
> 
> Regards
> HJR

Thank you! I was unaware of this functionality.

Actually I find extremely useful comments like: #workaround for bug xxxxxx
or
#modified by xxxxx (date xx/xx/xxxx)
in a pfile.

I believe a separate changelog file is also handy but having a track in the pfile itself is much faster (always given my poor DBA skill).

Grateful for the new knowledge.

-- 
Fabrizio Magni

fabrizio.magni_at_mycontinent.com

replace mycontinent with europe

Received on Sat Oct 23 2004 - 04:14:41 CDT