Thursday, 26 September 2013

Parameter processes in oracle DB

How to update parameter processes value in oracle Database
1. Login to oracle
$sqlplus SYS as SYSDBA
2. Check the current processes value
$SQL> show parameter processes;
3. update it to the desired value, for eg: updating to 500
$SQL>alter system set processes=500 scope=spfile;
$SQL> commit
$SQL>shutdown immediate
$SQL> startup
4. you are done, recheck the value.

No comments:

Post a Comment