oracle 10G porcess修改

show parameter process

show parameter session

select * from v$session;

alter system set processes=1000 scope=spfile;

因为sessions=(1.1*process 5) ，所以修改process可以改变sessions;

 

shutdown immediate;

stop oracleservice;

start oracleservice;

shutdown immediate;