Jan 11, 2013
52 Views
0 0

Parameter processes in oracle DB

Written by

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.

 

Article Categories:
Databases

Leave a Comment

Your email address will not be published. Required fields are marked *