sort_area_size
SQL> select name ,issys_modifiable from v$parameter where name like 'sort_%';
NAME ISSYS_MOD
---------------------------------------------------------------- ---------
sort_area_size DEFERRED
sort_area_retained_size DEFERRED
If the ISSYS_MODIFIABLE value is set to FALSE for a parameter, it means that the parameter cannot change its value in the lifetime of the instance; the
database needs to be restarted for changes to take effect. A parameter set to IMMEDATE value means that it is dynamic and can be set to change the present
active instance as well as future database restarts. A parameter set to DEFERRED is also dynamic, but changes only affect subsequent sessions, currently
active sessions will not be affected and retain the old parameter value.
如何修改,以让下一个session可以使用新的值呢?我是指在plsql里面。在oem里面修改似乎是可以的。我想改一个rac环境的sort_area_size
[ 本帖最后由 foxmile 于 2008-1-5 15:54 编辑 ]
SQL> select name ,issys_modifiable from v$parameter where name like 'sort_%';
NAME ISSYS_MOD
---------------------------------------------------------------- ---------
sort_area_size DEFERRED
sort_area_retained_size DEFERRED
If the ISSYS_MODIFIABLE value is set to FALSE for a parameter, it means that the parameter cannot change its value in the lifetime of the instance; the
database needs to be restarted for changes to take effect. A parameter set to IMMEDATE value means that it is dynamic and can be set to change the present
active instance as well as future database restarts. A parameter set to DEFERRED is also dynamic, but changes only affect subsequent sessions, currently
active sessions will not be affected and retain the old parameter value.
如何修改,以让下一个session可以使用新的值呢?我是指在plsql里面。在oem里面修改似乎是可以的。我想改一个rac环境的sort_area_size
[ 本帖最后由 foxmile 于 2008-1-5 15:54 编辑 ]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/79499/viewspace-417638/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/79499/viewspace-417638/