Shulou(Shulou.com)05/31 Report--

This article mainly introduces Oracle dynamic, static parameter modification rules, the text is very detailed, has a certain reference value, interested friends must read!

oracle dynamic static parameter modification rule

First, look at the properties (dynamic or static) of the oracle parameter you want to modify

SQL> select name,value,isses_modifiable,issys_modifiable from V$PARAMETER where name='max_dump_file_size';

Note:

isses_modifiable is Y, session level modified parameters, SQL>alter session set xxx=xxx ;;

issys_modifiable is Y, system-level modifiable parameter, SQL>alter system set xxx=xxx scope=xxx;

SQL>alter system reset _allow_resetlogs_corruption scope=spfile sid='*';

scope Parameter Description:

static parameter must specify scope

dynamic parameter issys_modifiable is IMMEDIATE without scope Default is both

dynamic parameter issys_modifiable must be DEFERRED with scope=spfile or derferred

parameter type

spfile

memory

both

deferred

static parameter (issys_modifiable is false)

Yes, restart server effective.

may not

may not

may not

dynamic parameter (issys_modifiable is immediate)

Yes, restart server effective.

Yes, effective immediately. Restart service disabled.

Yes, effective immediately. Rebooting the server still works.

can

dynamic parameter (issys_modifiable is deferred)

Yes, restart server effective.

may not

may not

Yes, the new session is valid

The above is "Oracle dynamic, static parameter modification rules are what" all the content of this article, thank you for reading! Hope to share the content to help everyone, more relevant knowledge, welcome to pay attention to the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.