恢复默认值
alter system reset open_cursors scope=spfile sid='*';
为修改加入注释
alter system set open_cursors=500 comment ='test 1' scope=both;
相关视图
select *
from v$spparameter
where name='control_files'
SID NAME VALUE DISPLAY_VALUE ISSPECIFIED ORDINAL UPDATE_COMMENT
* control_files /oradata/practice/control01.ctl /oradata/practice/control01.ctl TRUE 1
* control_files /oradata/practice/control02.ctl /oradata/practice/control02.ctl TRUE 2
* control_files /oradata/practice/control03.ctl /oradata/practice/control03.ctl TRUE 3
v$parameter2比v$parameter增加了 ORDINAL ,显示唯一的value
select *
from v$parameter2
where name='control_files'
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/6456/viewspace-112216/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/6456/viewspace-112216/