SQL>select name from v$parameter where issys_modifiable='DEFERRED';
NAME
------------------------------
backup_tape_io_slaves
audit_file_dest
object_cache_optimal_size
object_cache_max_size_percent
sort_area_size
sort_area_retained_size
olap_page_pool_size
SQL>select name,issys_modifiable from v$parameter where name='processes';
NAME ISSYS_MOD
------------------------------ ---------
processes FALSE
此参数为静态参数,只能以spfile启动的实例中,以scope=spfile修改。
SQL> show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/orcl/spfileedu.ora
SQL>alter system set processes=1400 scope=memory sid='orcl';
alter system set processes=1400 scope=memory sid='orcl'
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified
SQL>alter system set processes=1400 scope=both sid='orcl';
alter system set processes=1400 scope=both sid='edu1'
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified
SQL>alter system set processes=1400 scope=spfile sid='orcl';
System altered.