Parameter processes in oracle DB

0 0
Read Time:20 Second

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.

 

Happy
Happy
0 %
Sad
Sad
0 %
Excited
Excited
0 %
Sleppy
Sleppy
0 %
Angry
Angry
0 %
Surprise
Surprise
0 %

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

Leave a Reply

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