The INIT.ORA file 用例存储oracle启动参数设置。文件默认名称为INIT.ORA。
可以通过STARTUP command重命名。
In some systems, there will be multiple INIT.ORA files; this allows
different databases to have their own parameter settings. For example,
INITDEV.ORA may control the developer database, INITQA.ORA the QA
database, and INITPROD.ORA the production database.
可以有多个INIT.ORA files,不同数据库可以拥有自己的参数设置。
1.动态设置参数
You can modify certain parameters dynamically using the command:
ALTER SYSTEM SET parameter = value;
You can also set the parameters for a user session using the command:
ALTER SESSION SET parameter = value;
NOTE: Never assume the settings in the init.ora correctly represent the
settings of the database. Many of them can be modified dynamically, and
can take on new settings. These new settings do not reset when the
database is restarted.
注意:由于init.ora中的参数可以动态设置,所以init.ora中的设置不能完全正
确的反映出数据库的设置。当数据库重启时,动态设置的参数值不会被重置(数
据库按照init.ora中的设置初始参数)。
通过查询 V$PARAMETER table的isses_modifiable and issys_modifiable列可以
知道参数是非可变。
The isses_modifiable column <--> ALTER SESSION privilege
If this column is TRUE, then the user can do so; otherwise, the column
is FALSE.
The issys_modifiable column <--> ALTER SYSTEM privilege
It has three statuses:
IMMEDIATE (可以立即修改参数)
which indicates that the parameter is changeable and that the change
takes effect immediately
FALSE (不能动态修改参数)
which means that the parameter is not changeable dynamically
DEFERRED (可以修改,但要到下个会话)
which indicates that the parameter is changeable but that it will not
take effect until your next session