pfile和spfile的用法-修改process进程为例子

------pfile是静态参数可以直接在ora文件里面修改,然后删除spfile,一直修改pfile内容直到报错解决 最后在重建spfile ,关库重启

修改 process 进程

alter system set processes=300 scope = spfile;


create pfile from spfile;


shutdown immediate;


!echo '*.sga_target=2784M' >> '/u01/oracle/app/oracle/product/11.2.0/db/dbs/initorcl.ora'


create spfile from pfile = '/u01/oracle/app/oracle/product/11.2.0/db/dbs/initorcl.ora';


create pfile = '/oracle/tmp_init.ora' from spfile;