Re: changing init.ora and spfile

 Cool, I learned something new today.  I'd also wished for a feature like
that, and behold, it already existed!  Now if that column could somehow be
populated by the "create spfile from pfile" command, the feature would be
complete.  I suppose that would be difficult though, due to varying
commenting conventions.

Here it is in the docs for 10g:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_2013.htm#i2282157

--
Jason Heinrich


On Fri, Jul 31, 2009 at 2:25 PM, Bradd Piontek <piontekdd@xxxxxxxxx> wrote:

> Mark,  In 10g and 11g (pretty sure in 9i), you can do just that. The
> comments are stored in the UPDATE_COMMENT field in V$SPPARAMETER
> When the pfile is dumped out, the comments show up at the end of the line
>
>
>
> Bradd Piontek
>   "Next to doing a good job yourself,
>         the greatest joy is in having someone
>         else do a first-class job under your
>         direction."
>  -- William Feather
>
>
> On Fri, Jul 31, 2009 at 2:03 PM, Bobak, Mark <Mark.Bobak@xxxxxxxxxxxx>wrote:
>
>>  Hmm…it would be a nice enhancement to be able to do something like:
>>
>> alter system set db_cache_size = 4G scope=both comment=’Updated by M.Bobak
>> as per Change Control Request #78512’;
>>
>>
>>
>> And have that comment recorded somewhere in the data dictionary, and
>> automatically dumped when you did a ‘create pfile from spfile;’.
>>
>>
>>
>> Hmm….how do I file an enhancement request?
>>
>>
>>
>> -Mark
>>
>>

Other related posts: