Just came across the following and think it is good to share here.
When spfile is used in an Oracle database, and Oracle initialization parameters are modified, it is CAPABLE to attach a comment to the change:
alter system set ***=*** comment='Your comment' scope=both;
The COMMENT clause lets you associate a comment string with this change in the value of the parameter. If you also specify SPFILE, then this comment will appear in the parameter file to indicate the most recent change made to this parameter.
Where to see the changes? I have not figured out.
More Oracle DBA tips, please visit Oracle DBA Tips
When spfile is used in an Oracle database, and Oracle initialization parameters are modified, it is CAPABLE to attach a comment to the change:
alter system set ***=*** comment='Your comment' scope=both;
The COMMENT clause lets you associate a comment string with this change in the value of the parameter. If you also specify SPFILE, then this comment will appear in the parameter file to indicate the most recent change made to this parameter.
Where to see the changes? I have not figured out.
More Oracle DBA tips, please visit Oracle DBA Tips
No comments:
Post a Comment