Comments in spfile alter system

Comments are used much less often in spfile than they were in old init.ora’s. Syntax for them is like:

SQL> alter system set pga_aggregate_target=1g comment='Andrew Fraser 13-May-2010 was 390m'  scope=spfile sid='*' ;
Posted in Uncategorized
4 comments on “Comments in spfile alter system
  1. coskan says:


    Did you check if it is actually updating the update_comment column of v$parameter table. I tried it but it did not update the update_comment column of v$parameter v$system_parameter tables. Tried to convert spfile to pfile to see if it updates the init file no luck.

    The only way that I can see the comment was on alert log.

    Do you have the same behaviour ( is the DB I tried it on)

  2. Hi Coskan,

    Yes I do have the same behaviour – for some parameters. Parameter sga_target does not show the comment, while parameter pga_aggregate_target does show the comment.

    That is with version I haven’t checked to see if that is fixed in later versions.

    SQL>select name, value, update_comment from v$parameter where name in ('pga_aggregate_target','sga_target');


    Andrew Fraser 13-May-2010 was 390m

  3. Mike Spalinger says:

    If you updated the spfile (with scope=spfile), you should be able to see the comment in v$spparameter.

  4. Jay says:

    Spalinger – Thanks

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>