【Oracle】修改参数的同时添加注释
当修改参数时添加注释,我们会用到如下语句:
alter system set parameter=value
comment='description';
--修改参数需要有相应权限的用户去执行。
例如:
修改pga_aggregate_target 的大小为512M,并添加注释
SCOTT@ORA11GR2> conn / as sysdba
Connected.
SYS@ORA11GR2> alter system set pga_aggregate_target=512M
2 comment='Change 18-DEC-2016,AWR recommendation';
System altered.
SYS@ORA11GR2> select value,update_comment
2 from v$parameter
3 where name='pga_aggregate_target';
VALUE UPDATE_COMMENT
---------- ----------------------------------------
536870912 Change 18-DEC-2016,AWR recommendation